/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50720
 Source Host           : localhost:3306
 Source Schema         : com.dmibox.cmb.api

 Target Server Type    : MySQL
 Target Server Version : 50720
 File Encoding         : 65001

 Date: 01/01/2018 23:35:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `username` varchar(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '用户名',
  `nickname` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '昵称',
  `password` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '密码',
  `salt` char(6) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '密码盐',
  `avatar` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '头像',
  `email` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '电子邮箱',
  `loginfailure` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '失败次数',
  `logintime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登录时间',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `token` varchar(59) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT 'Session标识',
  `status` varchar(30) COLLATE utf8mb4_bin NOT NULL DEFAULT 'normal' COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='管理员表';

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` VALUES (1, 'admin', '系统管理员', '985388d187d899996f3d4c86d0b122b6', 'Ur5e1J', '/assets/img/avatar.png', 'admin@admin.com', 0, 1514814107, 1492186163, 1514814107, '651b0d70-43aa-4e17-b501-2ffeb963561a', 'normal');
COMMIT;

-- ----------------------------
-- Table structure for admin_log
-- ----------------------------
DROP TABLE IF EXISTS `admin_log`;
CREATE TABLE `admin_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `admin_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `username` varchar(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '管理员名字',
  `url` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '操作页面',
  `title` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '日志标题',
  `content` text COLLATE utf8mb4_bin NOT NULL COMMENT '内容',
  `ip` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT 'IP',
  `useragent` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT 'User-Agent',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `name` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='管理员日志表';

-- ----------------------------
-- Records of admin_log
-- ----------------------------
BEGIN;
INSERT INTO `admin_log` VALUES (46, 0, 'Unknown', '/admin/index/login', '登录', '{\"__token__\":\"1d51ff40cc8c8ec90bab56e91af168ce\",\"username\":\"adminin\"}', '172.20.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36', 1513498691);
INSERT INTO `admin_log` VALUES (47, 1, 'admin', '/admin/index/login', '登录', '{\"__token__\":\"1690f8ebd1aef0257d963158ece159bc\",\"username\":\"admin\"}', '172.20.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36', 1513498696);
INSERT INTO `admin_log` VALUES (48, 1, 'admin', '/admin/index/login', '登录', '{\"__token__\":\"7d86f6a214098b0fc1f9a649452651b3\",\"username\":\"admin\"}', '172.20.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36', 1513499014);
INSERT INTO `admin_log` VALUES (49, 1, 'admin', '/admin/index/login', '登录', '{\"__token__\":\"df1c845aea03538be9a5197da7eb3391\",\"username\":\"admin\"}', '172.20.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36', 1513502547);
INSERT INTO `admin_log` VALUES (50, 1, 'admin', '/admin/index/login?url=%2Fadmin%2FIndex%2Findex', '登录', '{\"url\":\"\\/admin\\/Index\\/index\",\"__token__\":\"17899e4927985771c56203438bd545e4\",\"username\":\"admin\"}', '172.20.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36', 1513566998);
COMMIT;

-- ----------------------------
-- Table structure for attachment
-- ----------------------------
DROP TABLE IF EXISTS `attachment`;
CREATE TABLE `attachment` (
  `id` int(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `url` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '物理路径',
  `imagewidth` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '宽度',
  `imageheight` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '宽度',
  `imagetype` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图片类型',
  `imageframes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '图片帧数',
  `filesize` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `mimetype` varchar(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT 'mime类型',
  `extparam` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '透传数据',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建日期',
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `uploadtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上传时间',
  `storage` enum('local','oss','upyun') COLLATE utf8mb4_bin NOT NULL DEFAULT 'local' COMMENT '存储位置',
  `sha1` varchar(40) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '文件 sha1编码',
  `imagename` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '图片原名称',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `sha1` (`sha1`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='附件表';

-- ----------------------------
-- Records of attachment
-- ----------------------------
BEGIN;
INSERT INTO `attachment` VALUES (1, 'qweqwe', 0, 0, '', 0, 0, '', '', 0, 0, 0, 'local', '', '');
INSERT INTO `attachment` VALUES (2, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/f2f4b65cfe7b8cc4ab7362ac0ab0c734d6eb2abf.png', 28, 30, 'png', 0, 1391, 'image/png', '', 1513782256, 1513782256, 1513782256, 'oss', 'f2f4b65cfe7b8cc4ab7362ac0ab0c734d6eb2abf', 'wxc453fe77107af46b.o6zAJs_I6KkHObOXdcugRWZS_WEs.32821cd5be09638d5726414de9fc6594');
INSERT INTO `attachment` VALUES (3, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/cd7e1a876e831cc967b60db203ee610a700b268c.png', 44, 44, 'png', 0, 1352, 'image/png', '', 1513782343, 1513782343, 1513782343, 'oss', 'cd7e1a876e831cc967b60db203ee610a700b268c', 'wxc453fe77107af46b.o6zAJs_I6KkHObOXdcugRWZS_WEs.b99184b27d3b69d266bb74974d8530c6');
INSERT INTO `attachment` VALUES (4, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/c8a31242408e645d3b1b4d13af51b4f14dc35359.png', 26, 26, 'png', 0, 1154, 'image/png', '', 1513782852, 1513782852, 1513782852, 'oss', 'c8a31242408e645d3b1b4d13af51b4f14dc35359', 'wxc453fe77107af46b.o6zAJs_I6KkHObOXdcugRWZS_WEs.7f400fa225f4faee37899688de52c5fd');
INSERT INTO `attachment` VALUES (5, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/9fa9e84c4f353579e7d19994abdc91811306189d.png', 58, 58, 'png', 0, 1116, 'image/png', '', 1513782948, 1513782948, 1513782948, 'oss', '9fa9e84c4f353579e7d19994abdc91811306189d', 'wxc453fe77107af46b.o6zAJs_I6KkHObOXdcugRWZS_WEs.1db187ae5be3121acf357881109a7e0d');
INSERT INTO `attachment` VALUES (6, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/fd9e943c492b0c66394408e694b63cab91d40166.png', 81, 81, 'png', 0, 17179, 'image/png', '', 1513783018, 1513783018, 1513783018, 'oss', 'fd9e943c492b0c66394408e694b63cab91d40166', 'wxc453fe77107af46b.o6zAJs_I6KkHObOXdcugRWZS_WEs.17b9f4f19c0f79b1a409c898a198ce88');
INSERT INTO `attachment` VALUES (7, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/ba087b818e4d26ca5b94402f5c6135a7134ee1c0.png', 26, 32, 'png', 0, 1530, 'image/png', '', 1513783459, 1513783459, 1513783459, 'oss', 'ba087b818e4d26ca5b94402f5c6135a7134ee1c0', 'wxc453fe77107af46b.o6zAJs_I6KkHObOXdcugRWZS_WEs.beeb8c91d7657c63669084f9af34b784');
INSERT INTO `attachment` VALUES (8, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/f42352f317acb083dc940ef63aa0c665cf91db5d.png', 81, 81, 'png', 0, 18018, 'image/png', '', 1513783464, 1513783464, 1513783464, 'oss', 'f42352f317acb083dc940ef63aa0c665cf91db5d', 'wxc453fe77107af46b.o6zAJs_I6KkHObOXdcugRWZS_WEs.9116ea6e609765f05a9e3531f3fa7372');
INSERT INTO `attachment` VALUES (9, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/bb92b46b66176ec1ef0f6a573f70abd248792f3f.png', 81, 81, 'png', 0, 18455, 'image/png', '', 1513783564, 1513783564, 1513783564, 'oss', 'bb92b46b66176ec1ef0f6a573f70abd248792f3f', 'wxc453fe77107af46b.o6zAJs_I6KkHObOXdcugRWZS_WEs.04125b3a91a3aaba789b2160cc26fd8d');
INSERT INTO `attachment` VALUES (10, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/913d50bf7ef56228471169db447a1806ee0e57ba.png', 27, 18, 'png', 0, 1221, 'image/png', '', 1513783674, 1513783674, 1513783674, 'oss', '913d50bf7ef56228471169db447a1806ee0e57ba', 'wxc453fe77107af46b.o6zAJs_I6KkHObOXdcugRWZS_WEs.ae3b35ca08156f53fd55c7f1dd080ec8');
INSERT INTO `attachment` VALUES (11, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/8892856201860876306613d6f32236cc8fb9650e.png', 12, 24, 'png', 0, 1349, 'image/png', '', 1513783812, 1513783812, 1513783812, 'oss', '8892856201860876306613d6f32236cc8fb9650e', 'wxc453fe77107af46b.o6zAJs_I6KkHObOXdcugRWZS_WEs.da7ba11be4dadd6ce264c7b8ea3e03d4');
INSERT INTO `attachment` VALUES (12, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/ebbe50fcd84c6013b7984bd21da52522b791473a.png', 58, 58, 'png', 0, 1129, 'image/png', '', 1513784607, 1513784607, 1513784607, 'oss', 'ebbe50fcd84c6013b7984bd21da52522b791473a', 'wxc453fe77107af46b.o6zAJs_I6KkHObOXdcugRWZS_WEs.183d739f941a7c3e1c11f226bb789d59');
INSERT INTO `attachment` VALUES (13, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/3d4997adf91d7651cc2272d46fabe9014be88b49.png', 81, 81, 'png', 0, 18051, 'image/png', '', 1513785202, 1513785202, 1513785202, 'oss', '3d4997adf91d7651cc2272d46fabe9014be88b49', 'wxc453fe77107af46b.o6zAJs_I6KkHObOXdcugRWZS_WEs.9f223f94f25a3c105fb91ce941c32def');
INSERT INTO `attachment` VALUES (14, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/07f26ca328fe2325539d591f7e700c4dbfbc0e4a.png', 11, 11, 'png', 0, 1127, 'image/png', '', 1513786132, 1513786132, 1513786132, 'oss', '07f26ca328fe2325539d591f7e700c4dbfbc0e4a', 'wxc453fe77107af46b.o6zAJs_I6KkHObOXdcugRWZS_WEs.c8b88b6295e2066f95ebdf9ddc2c9780');
INSERT INTO `attachment` VALUES (15, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/90bdd088d40298d2dbd59fee48652b091818ce0f.png', 750, 10, 'png', 0, 2858, 'image/png', '', 1513786153, 1513786153, 1513786153, 'oss', '90bdd088d40298d2dbd59fee48652b091818ce0f', 'wxc453fe77107af46b.o6zAJs_I6KkHObOXdcugRWZS_WEs.df44fcf4dd757e90459166278cbfde29');
INSERT INTO `attachment` VALUES (16, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/23e5e654f7e300a3e658338669877c0a62dbc70c.jpg', 1080, 1920, 'jpg', 0, 861367, 'image/jpg', '', 1513790558, 1513790558, 1513790558, 'oss', '23e5e654f7e300a3e658338669877c0a62dbc70c', 'tmp_a914efe90c2154b5ba497d3100eb4862');
INSERT INTO `attachment` VALUES (17, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/f6f53ddf41c64db0f8457c7936958ad68961494d.jpg', 1080, 1920, 'jpg', 0, 298578, 'image/jpg', '', 1513790573, 1513790573, 1513790573, 'oss', 'f6f53ddf41c64db0f8457c7936958ad68961494d', 'tmp_1fd0249b9c0812639652899f10f813e8');
INSERT INTO `attachment` VALUES (18, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/23285b6434d6bf240a48946dec13415ababc9305.jpg', 750, 1334, 'jpg', 0, 44524, 'image/jpg', '', 1513790579, 1513790579, 1513790579, 'oss', '23285b6434d6bf240a48946dec13415ababc9305', 'tmp_38e1f2269155fd5853bd4df073970de9');
INSERT INTO `attachment` VALUES (19, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/9f394a47e3d2be99217e947d781b35528f8cbbf2.png', 81, 81, 'png', 0, 17188, 'image/png', '', 1513790843, 1513790843, 1513790843, 'oss', '9f394a47e3d2be99217e947d781b35528f8cbbf2', 'wxc453fe77107af46b.o6zAJs12a7S8-Xk-zQ_pgHAAlSRU.2c81a66af3e6f713d8421a4218cd011c');
INSERT INTO `attachment` VALUES (20, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/82dd1285c46e70fb6e3a40b44ae05bab44fb932f.jpg', 1080, 1920, 'jpg', 0, 104265, 'image/jpg', '', 1513791534, 1513791534, 1513791534, 'oss', '82dd1285c46e70fb6e3a40b44ae05bab44fb932f', 'tmp_a5ab70a217c6d19a55b8f3c633fa8e6b');
INSERT INTO `attachment` VALUES (21, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/8e96bb23944fedc698ea79d5a359a02234d3bf3f.jpg', 1050, 1399, 'jpg', 0, 165851, 'image/jpg', '', 1513791590, 1513791590, 1513791590, 'oss', '8e96bb23944fedc698ea79d5a359a02234d3bf3f', 'tmp_bd75edca9c0063c66d7d6098d64bc1d1');
INSERT INTO `attachment` VALUES (22, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/938fdc144cbc783ba176ea96d264804db52ba9e1.jpg', 1080, 1440, 'jpg', 0, 295510, 'image/jpg', '', 1513791605, 1513791605, 1513791605, 'oss', '938fdc144cbc783ba176ea96d264804db52ba9e1', 'tmp_e1df7e4d71ca54b07246aa6a573296af');
INSERT INTO `attachment` VALUES (23, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/aac3d555ef9628627449cd4545e809a6eb7cf725.jpg', 1080, 1440, 'jpg', 0, 404594, 'image/jpg', '', 1513837242, 1513837242, 1513837242, 'oss', 'aac3d555ef9628627449cd4545e809a6eb7cf725', 'tmp_0bf1e29ac9a6b9f95bee03a63d308996');
INSERT INTO `attachment` VALUES (24, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/2268f76b8405500f5108b138798def29fc146c45.jpg', 1080, 1440, 'jpg', 0, 371603, 'image/jpg', '', 1513837256, 1513837256, 1513837256, 'oss', '2268f76b8405500f5108b138798def29fc146c45', 'tmp_4fb57ba994cf3535d5a477114e2db8c9');
INSERT INTO `attachment` VALUES (25, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/f5b3322405cc36f81d7b23fa8abf4404083e7c3d.jpg', 1080, 1440, 'jpg', 0, 411139, 'image/jpg', '', 1513837259, 1513837259, 1513837259, 'oss', 'f5b3322405cc36f81d7b23fa8abf4404083e7c3d', 'tmp_eea79bdb2b4058c67801ca3e35a22d33');
INSERT INTO `attachment` VALUES (26, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/de453e2ddd20ad4d68cbe8983f8c79bde3404cdc.jpg', 1080, 1440, 'jpg', 0, 264689, 'image/jpg', '', 1513837280, 1513837280, 1513837280, 'oss', 'de453e2ddd20ad4d68cbe8983f8c79bde3404cdc', 'tmp_4f930c50fe9f15e8d759a4668e45c163');
INSERT INTO `attachment` VALUES (27, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/34a51ba737231b77c8e8320e7a2d14e4a296a5de.jpg', 1080, 1440, 'jpg', 0, 350063, 'image/jpg', '', 1513837396, 1513837396, 1513837396, 'oss', '34a51ba737231b77c8e8320e7a2d14e4a296a5de', 'tmp_c9c62db6a6565df62b6d610c3e0d0c35');
INSERT INTO `attachment` VALUES (28, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/3a213bd63243ef4b3575a0e44ae06327a60dab38.jpg', 2550, 3507, 'jpg', 0, 1305246, 'image/jpg', '', 1514442161, 1514442161, 1514442161, 'oss', '3a213bd63243ef4b3575a0e44ae06327a60dab38', 'tmp_bbd6e8747b624d3038a99c497847ab93');
INSERT INTO `attachment` VALUES (29, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/f5d7206c1969d2768bba85fd945f724b1ef13c49.jpg', 4032, 3024, 'jpg', 0, 2365361, 'image/jpg', '', 1514442291, 1514442291, 1514442291, 'oss', 'f5d7206c1969d2768bba85fd945f724b1ef13c49', 'tmp_3a06f3aa61e1fc2fa62f1af297c2ac1d');
INSERT INTO `attachment` VALUES (30, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/6c40926fa023bedf23a113e42828efda9f6a06cd.jpg', 4032, 3024, 'jpg', 0, 3071497, 'image/jpg', '', 1514442562, 1514442562, 1514442562, 'oss', '6c40926fa023bedf23a113e42828efda9f6a06cd', 'tmp_3a8bd04ef8e3b45002b0f24b9b96251c');
INSERT INTO `attachment` VALUES (31, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/776849fced6b0955f6764cd2a0b12fb67330c680.jpg', 1080, 1920, 'jpg', 0, 473697, 'image/jpg', '', 1514443035, 1514443035, 1514443035, 'oss', '776849fced6b0955f6764cd2a0b12fb67330c680', 'tmp_defec736ac8cc020acdd5bb57c47d016');
INSERT INTO `attachment` VALUES (32, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/5dd7eb777f9a2aa3e7464c21d071a68cbbe777a5.jpg', 1080, 1920, 'jpg', 0, 152860, 'image/jpg', '', 1514443051, 1514443051, 1514443051, 'oss', '5dd7eb777f9a2aa3e7464c21d071a68cbbe777a5', 'tmp_ceb7d52a8bea59a69703828e854365ba');
INSERT INTO `attachment` VALUES (33, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/4f491f4dbf915f1d14fd0a97a2b93792a03a2f08.jpg', 1080, 1920, 'jpg', 0, 382051, 'image/jpg', '', 1514444154, 1514444154, 1514444154, 'oss', '4f491f4dbf915f1d14fd0a97a2b93792a03a2f08', 'tmp_93f75f5bc84cf3261bcd326a72578529');
INSERT INTO `attachment` VALUES (34, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/f5f1f72bc9a16f4dee90a40825c03f0a1ce2c736.jpg', 1080, 1440, 'jpg', 0, 269956, 'image/jpg', '', 1514444169, 1514444169, 1514444169, 'oss', 'f5f1f72bc9a16f4dee90a40825c03f0a1ce2c736', 'tmp_fdc64f00b0dc8273197c7cbcab7163ba');
INSERT INTO `attachment` VALUES (35, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/6ae964ed0091f7bd65909fde08eb02cf2c3e3cef.jpg', 1080, 1440, 'jpg', 0, 195051, 'image/jpg', '', 1514444176, 1514444176, 1514444176, 'oss', '6ae964ed0091f7bd65909fde08eb02cf2c3e3cef', 'tmp_c27831748f0192c5caef458b466cbc6c');
INSERT INTO `attachment` VALUES (36, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/dcf4505165dc5f93107c26c190690db4445d0175.jpg', 1080, 1440, 'jpg', 0, 306821, 'image/jpg', '', 1514530326, 1514530326, 1514530326, 'oss', 'dcf4505165dc5f93107c26c190690db4445d0175', 'tmp_1abd2e73f5c946fa2a25a2cbba738890');
INSERT INTO `attachment` VALUES (37, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/66a20086ce9ec50a54118a2bdfbe2963bf5e15a6.jpg', 1080, 1440, 'jpg', 0, 253813, 'image/jpg', '', 1514530381, 1514530381, 1514530381, 'oss', '66a20086ce9ec50a54118a2bdfbe2963bf5e15a6', 'tmp_4996e8cbe3b491c200121fa0bb773839');
INSERT INTO `attachment` VALUES (38, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/0f597b932905ec17213617a8fa733227e4b0d9d4.jpg', 1080, 1440, 'jpg', 0, 292138, 'image/jpg', '', 1514530387, 1514530387, 1514530387, 'oss', '0f597b932905ec17213617a8fa733227e4b0d9d4', 'tmp_5a590f1ca771821f884af576e3e460c1');
INSERT INTO `attachment` VALUES (39, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/3fe670b2adefe36620127a3dcbcec0999abd279f.jpg', 1080, 1440, 'jpg', 0, 313266, 'image/jpg', '', 1514530437, 1514530437, 1514530437, 'oss', '3fe670b2adefe36620127a3dcbcec0999abd279f', 'tmp_b22d157ac2fad6bef528887de91d5c83');
INSERT INTO `attachment` VALUES (40, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/d465d6fa43d4f9230d9cad08f400f3513311742d.jpg', 1440, 1080, 'jpg', 0, 369099, 'image/jpg', '', 1514530749, 1514530749, 1514530749, 'oss', 'd465d6fa43d4f9230d9cad08f400f3513311742d', 'tmp_27440f4cc4c8f3b7aad6e2c0d3a1a923');
INSERT INTO `attachment` VALUES (41, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/07a0daa2e21e4a0d364c75efa4f39e1cf91aa11f.jpg', 1080, 1440, 'jpg', 0, 272249, 'image/jpg', '', 1514530765, 1514530765, 1514530765, 'oss', '07a0daa2e21e4a0d364c75efa4f39e1cf91aa11f', 'tmp_5dfa81fc8fbea0b4df10373111a1f235');
INSERT INTO `attachment` VALUES (42, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/3d8390f53b3c5455c8bd8deb8fd15ec5c2cbd6e6.jpg', 1080, 1440, 'jpg', 0, 312152, 'image/jpg', '', 1514530769, 1514530769, 1514530769, 'oss', '3d8390f53b3c5455c8bd8deb8fd15ec5c2cbd6e6', 'tmp_57cc33e8e6ea167e9d9f25d80f5c9db2');
INSERT INTO `attachment` VALUES (43, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/3313378839fa19b9449261d3cea482883cb23375.jpg', 1080, 1440, 'jpg', 0, 272681, 'image/jpg', '', 1514530790, 1514530790, 1514530790, 'oss', '3313378839fa19b9449261d3cea482883cb23375', 'tmp_5b0c00c7de68353814a9e39b2e675ace');
INSERT INTO `attachment` VALUES (44, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/e430ad05e369ebecde75c50a3ac1f3014355fe59.jpg', 1080, 1440, 'jpg', 0, 687939, 'image/jpg', '', 1514537038, 1514537038, 1514537038, 'oss', 'e430ad05e369ebecde75c50a3ac1f3014355fe59', 'tmp_ff2ce1a25e39da544fe38bbc0c89ee3f');
INSERT INTO `attachment` VALUES (45, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/8b9694cf92f71a86e7c8a5f778ee9e1e620d5aef.jpg', 1080, 1440, 'jpg', 0, 635931, 'image/jpg', '', 1514537050, 1514537050, 1514537050, 'oss', '8b9694cf92f71a86e7c8a5f778ee9e1e620d5aef', 'tmp_1a2e31f42e5443846db53cc11604099e');
INSERT INTO `attachment` VALUES (46, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/6de9bd3f3bc7b06a7c03fc045ae8090ae7455f99.jpg', 1080, 1440, 'jpg', 0, 615845, 'image/jpg', '', 1514537059, 1514537059, 1514537059, 'oss', '6de9bd3f3bc7b06a7c03fc045ae8090ae7455f99', 'tmp_fc48b7a0ae00c70a6acebd4a1de25d71');
INSERT INTO `attachment` VALUES (47, 'http://gy-yxc.oss-cn-beijing.aliyuncs.com/4f0512f7a9c1416b56cf1c4f7f1627b230ecdd04.jpg', 1080, 1440, 'jpg', 0, 234671, 'image/jpg', '', 1514537080, 1514537080, 1514537080, 'oss', '4f0512f7a9c1416b56cf1c4f7f1627b230ecdd04', 'tmp_b5df5c006502ebc3d4238d122f7dd635');
COMMIT;

-- ----------------------------
-- Table structure for auth_group
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父组别',
  `name` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '组名',
  `rules` text COLLATE utf8mb4_bin NOT NULL COMMENT '规则ID',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` varchar(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='分组表';

-- ----------------------------
-- Records of auth_group
-- ----------------------------
BEGIN;
INSERT INTO `auth_group` VALUES (1, 0, '超级管理员', '*', 1490883540, 1490883540, 'normal');
COMMIT;

-- ----------------------------
-- Table structure for auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `auth_group_access`;
CREATE TABLE `auth_group_access` (
  `uid` int(10) unsigned NOT NULL COMMENT '会员ID',
  `group_id` int(10) unsigned NOT NULL COMMENT '级别ID',
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`) USING BTREE,
  KEY `uid` (`uid`) USING BTREE,
  KEY `group_id` (`group_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='权限分组表';

-- ----------------------------
-- Records of auth_group_access
-- ----------------------------
BEGIN;
INSERT INTO `auth_group_access` VALUES (1, 1);
COMMIT;

-- ----------------------------
-- Table structure for auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `auth_rule`;
CREATE TABLE `auth_rule` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('menu','file') COLLATE utf8mb4_bin NOT NULL DEFAULT 'file' COMMENT 'menu为菜单,file为权限节点',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
  `name` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '规则名称',
  `title` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '规则名称',
  `icon` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '图标',
  `condition` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '条件',
  `remark` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '备注',
  `ismenu` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为菜单',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
  `status` varchar(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '状态',
  `module` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '模块标识',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE,
  KEY `weigh` (`weigh`) USING BTREE,
  KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=207 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='节点表';

-- ----------------------------
-- Records of auth_rule
-- ----------------------------
BEGIN;
INSERT INTO `auth_rule` VALUES (1, 'file', 0, '/admin/dashboard/index', '控制台', 'fa fa-dashboard', '', '用于展示当前系统中的统计数据、统计报表及重要实时数据\r', 1, 1497429920, 1497429920, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (2, 'file', 0, '/admin/auth', '团队管理', 'fa fa-group', '', '', 1, 1497429920, 1499965948, 2, 'normal', '');
INSERT INTO `auth_rule` VALUES (3, 'file', 2, '/admin/auth/admin', '成员管理', 'fa fa-user', '', '一个管理员可以有多个角色组,左侧的菜单根据管理员所拥有的权限进行生成', 1, 1497429920, 1499965959, 118, 'normal', '');
INSERT INTO `auth_rule` VALUES (4, 'file', 3, '/admin/auth/admin/index', '查看', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 117, 'normal', '');
INSERT INTO `auth_rule` VALUES (5, 'file', 3, '/admin/auth/admin/add', '添加', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 116, 'normal', '');
INSERT INTO `auth_rule` VALUES (6, 'file', 3, '/admin/auth/admin/edit', '编辑', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 115, 'normal', '');
INSERT INTO `auth_rule` VALUES (7, 'file', 3, '/admin/auth/admin/del', '删除', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 114, 'normal', '');
INSERT INTO `auth_rule` VALUES (8, 'file', 2, '/admin/auth/adminlog', '操作日志', 'fa fa-list-alt', '', '管理员可以查看自己所拥有的权限的管理员日志', 1, 1497429920, 1497430307, 113, 'normal', '');
INSERT INTO `auth_rule` VALUES (9, 'file', 2, '/admin/auth/group', '角色管理', 'fa fa-group', '', '角色组可以有多个,角色有上下级层级关系,如果子角色有角色组和管理员的权限则可以派生属于自己组别下级的角色组或管理员', 1, 1497429920, 1499965973, 109, 'normal', '');
INSERT INTO `auth_rule` VALUES (10, 'file', 2, '/admin/auth/rule', '规则管理', 'fa fa-bars', '', '规则通常对应一个控制器的方法,同时左侧的菜单栏数据也从规则中体现,通常建议通过控制台进行生成规则节点', 1, 1497429920, 1497430581, 104, 'normal', '');
INSERT INTO `auth_rule` VALUES (11, 'file', 8, '/admin/auth/adminlog/index', '查看', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 112, 'normal', '');
INSERT INTO `auth_rule` VALUES (12, 'file', 8, '/admin/auth/adminlog/detail', '详情', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 111, 'normal', '');
INSERT INTO `auth_rule` VALUES (13, 'file', 8, '/admin/auth/adminlog/del', '删除', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 110, 'normal', '');
INSERT INTO `auth_rule` VALUES (14, 'file', 9, '/admin/auth/group/index', '查看', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 108, 'normal', '');
INSERT INTO `auth_rule` VALUES (15, 'file', 9, '/admin/auth/group/add', '添加', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 107, 'normal', '');
INSERT INTO `auth_rule` VALUES (16, 'file', 9, '/admin/auth/group/edit', '编辑', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 106, 'normal', '');
INSERT INTO `auth_rule` VALUES (17, 'file', 9, '/admin/auth/group/del', '删除', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 105, 'normal', '');
INSERT INTO `auth_rule` VALUES (19, 'file', 10, '/admin/auth/rule/index', '查看', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 103, 'normal', '');
INSERT INTO `auth_rule` VALUES (20, 'file', 10, '/admin/auth/rule/add', '添加', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 102, 'normal', '');
INSERT INTO `auth_rule` VALUES (21, 'file', 10, '/admin/auth/rule/edit', '编辑', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 101, 'normal', '');
INSERT INTO `auth_rule` VALUES (22, 'file', 10, '/admin/auth/rule/del', '删除', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 100, 'normal', '');
INSERT INTO `auth_rule` VALUES (23, 'file', 0, '/admin/general', '系统管理', 'fa fa-cogs', '', '', 1, 1497429920, 1497430169, 2, 'normal', '');
INSERT INTO `auth_rule` VALUES (29, 'file', 23, '/admin/general/config/index', '系统配置', 'fa fa-cog', '', '', 1, 1497429920, 1497430683, 60, 'normal', '');
INSERT INTO `auth_rule` VALUES (30, 'file', 23, '/admin/general/crontab', '定时任务', 'fa fa-tasks', '', '类似于Linux的Crontab定时任务,可以按照设定的时间进行任务的执行,目前仅支持三种任务:请求URL、执行SQL、执行Shell', 1, 1497429920, 1497429920, 47, 'normal', '');
INSERT INTO `auth_rule` VALUES (31, 'file', 23, '/admin/general/database/index', '数据库管理', 'fa fa-database', '', '可在线进行一些简单的数据库表优化或修复,查看表结构和数据。也可以进行SQL语句的操作', 1, 1497429920, 1497429920, 41, 'normal', '');
INSERT INTO `auth_rule` VALUES (32, 'file', 23, '/admin/general/profile', '个人配置', 'fa fa-user\r', '', '', 1, 1497429920, 1497429920, 34, 'normal', '');
INSERT INTO `auth_rule` VALUES (33, 'file', 30, '/admin/general/crontab/index', '查看', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 46, 'normal', '');
INSERT INTO `auth_rule` VALUES (34, 'file', 30, '/admin/general/crontab/add', '添加', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 45, 'normal', '');
INSERT INTO `auth_rule` VALUES (35, 'file', 30, '/admin/general/crontab/edit', '编辑', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 44, 'normal', '');
INSERT INTO `auth_rule` VALUES (36, 'file', 30, '/admin/general/crontab/del', '删除', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 43, 'normal', '');
INSERT INTO `auth_rule` VALUES (37, 'file', 32, '/admin/general/profile/index', '查看', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 33, 'normal', '');
INSERT INTO `auth_rule` VALUES (38, 'file', 32, '/admin/general/profile/update', '更新个人信息', 'fa fa-circle-o', '', '', 0, 1497429920, 1497429920, 32, 'normal', '');
INSERT INTO `auth_rule` VALUES (53, 'file', 0, '/member/member/admin/', '用户管理', 'fa fa-user', '', '', 1, 1502070083, 1502070083, 1, '', '');
INSERT INTO `auth_rule` VALUES (54, 'file', 53, '/member/member/admin/index', '用户管理', 'fa fa-user', '', '', 1, 1502075710, 1502076595, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (55, 'file', 53, '/member/fans/admin/index', '粉丝管理', 'fa fa-user-md', '', '', 1, 1502075764, 1502076616, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (85, 'file', 0, '/statistics', '统计日志', 'fa fa-bar-chart', '', '', 0, 1502084783, 1502085818, 1, '', 'statistics');
INSERT INTO `auth_rule` VALUES (86, 'file', 85, '/statistics/statistics/index', '数据统计', 'fa fa-bar-chart-o', '', '', 1, 1502084783, 1502085869, 0, 'normal', 'statistics');
INSERT INTO `auth_rule` VALUES (87, 'file', 85, '/log/log/index', '日志记录', 'fa fa-table', '', '', 1, 1502084783, 1502085853, 0, 'normal', 'statistics');
INSERT INTO `auth_rule` VALUES (135, 'file', 0, '/wechat', '微信配置', 'fa fa-wechat', '', '', 0, 1502421869, 1502421869, 1, 'normal', 'wechat');
INSERT INTO `auth_rule` VALUES (136, 'file', 135, '/wechat/config/index', '微信配置', 'fa fa-cog', '', '', 1, 1502421869, 1502421869, 0, 'normal', 'wechat');
INSERT INTO `auth_rule` VALUES (140, 'file', 135, '/wechat/admin/auth/index', '鉴权号', 'fa fa-bars', '', '', 1, 1502421869, 1502421869, 0, 'normal', 'wechat');
INSERT INTO `auth_rule` VALUES (142, 'file', 135, '/wechat/admin/server/index', '公众号', 'fa fa-bars', '', '', 1, 1502421869, 1502421869, 0, 'normal', 'wechat');
INSERT INTO `auth_rule` VALUES (145, 'file', 0, '/partner/admin/partner', '合作方', 'fa fa-codepen', '', '', 0, 0, 0, 1, '', '');
INSERT INTO `auth_rule` VALUES (147, 'file', 145, '/partner/admin/manager/index', '管理员管理', 'fa fa-user-o', '', '', 0, 0, 0, 0, 'hidden', '');
INSERT INTO `auth_rule` VALUES (148, 'file', 0, '/attachment/attachment', '附件管理', 'fa fa-files-o', '', '', 1, 1503362816, 1503362816, 2, 'normal', 'attachment');
INSERT INTO `auth_rule` VALUES (149, 'file', 148, '/attachment/attachment/index', '查看', '', '', '', 0, 1503362816, 1503362816, 0, 'normal', 'attachment');
INSERT INTO `auth_rule` VALUES (151, 'file', 148, '/attachment/attachment/del', '删除', '0', '', '', 0, 1503362817, 1503362817, 0, 'normal', 'attachment');
INSERT INTO `auth_rule` VALUES (160, 'file', 140, '/wechat/admin/auth/index', '查看', 'fa fa-circle-o', '', '', 0, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (161, 'file', 140, '/wechat/admin/auth/add', '添加', 'fa fa-circle-o', '', '', 0, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (162, 'file', 140, '/wechat/admin/auth/edit', '编辑', 'fa fa-circle-o', '', '', 0, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (163, 'file', 140, '/wechat/admin/auth/del', '删除', 'fa fa-circle-o', '', '', 0, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (164, 'file', 142, '/wechat/admin/server/index', '查看', 'fa fa-circle-o', '', '', 0, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (165, 'file', 142, '/wechat/admin/server/edit', '编辑', 'fa fa-circle-o', '', '', 0, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (166, 'file', 142, '/wechat/admin/server/add', '添加', 'fa fa-circle-o', '', '', 0, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (167, 'file', 142, '/wechat/admin/server/del', '删除', 'fa fa-circle-o', '', '', 0, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (174, 'file', 136, '/wechat/config/index', '查看', 'fa fa-circle-o', '', '', 0, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (175, 'file', 136, '/wechat/config/edit', '编辑', 'fa fa-circle-o', '', '', 0, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (177, 'file', 31, '/admin/general/database/index', '查看', 'fa fa-circle-o', '', '', 0, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (178, 'file', 31, '/admin/general/database/query', '查询', 'fa fa-circle-o', '', '', 0, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (179, 'file', 31, '/admin/general/database/doquery', '执行', 'fa fa-circle-o', '', '', 0, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (181, 'file', 0, '/goods/point/', '积分兑换', 'fa fa-bars', '', '', 1, 1502421869, 1502421869, 1, 'normal', 'wechat');
INSERT INTO `auth_rule` VALUES (182, 'file', 181, '/goods/admin/index/index', '商品管理', '', '', '', 1, 1502421869, 1502421869, 0, 'normal', 'wechat');
INSERT INTO `auth_rule` VALUES (192, 'file', 181, '/goods/admin/goods_stock/index', '虚拟库存', '', '', '', 1, 1502421869, 1502421869, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (193, 'file', 181, '/goods/admin/order/index', '订单管理', '', '', '', 1, 1502421869, 1502421869, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (194, 'file', 0, '/user/', '用户管理', 'fa fa-user', '', '', 1, 1502421869, 1502421869, 1, 'normal', '');
INSERT INTO `auth_rule` VALUES (195, 'file', 194, '/user/admin/index/index', '用户列表', '', '', '', 1, 1502421869, 1502421869, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (196, 'file', 194, '/user/admin/index/dist', '分销商列表', '', '', '', 1, 1502421869, 1502421869, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (197, 'file', 194, '/user/admin/distributor/index', '分销商申请', '', '', '', 1, 1502421869, 1502421869, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (198, 'file', 194, '/user/admin/index/customer', '客户经理列表', '', '', '', 1, 1502421869, 1502421869, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (199, 'file', 0, '/product/', '贷款业务', 'fa fa-codepen', '', '', 1, 1502421869, 1502421869, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (200, 'file', 199, '/product/admin/product/index', '贷款产品管理', '', '', '', 1, 1502421869, 1502421869, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (201, 'file', 199, '/product/admin/order/index', '贷款订单管理', '', '', '', 1, 1502421869, 1502421869, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (202, 'file', 199, '/product/admin/order_trace/index', '订单跟踪日志', '', '', '', 1, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (203, 'file', 199, '/product/admin/order_reserve/index', '订单抢单日志', '', '', '', 1, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (204, 'file', 199, '/product/admin/question_template/index', '初核问题模板', '', '', '', 1, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (205, 'file', 199, '/product/admin/profile_template/index', '资料清单模板', '', '', '', 1, 0, 0, 0, 'normal', '');
INSERT INTO `auth_rule` VALUES (206, 'file', 194, '/user/admin/user_point_log/index', '积分变动日志', '', '', '', 1, 0, 0, 0, 'normal', '');
COMMIT;

-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '变量名',
  `group` varchar(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '分组',
  `title` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '变量标题',
  `tip` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '变量描述',
  `type` varchar(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '类型:string,text,int,bool,array,datetime,date,file',
  `value` text COLLATE utf8mb4_bin NOT NULL COMMENT '变量值',
  `content` text COLLATE utf8mb4_bin NOT NULL COMMENT '变量字典数据',
  `rule` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '验证规则',
  `extend` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '扩展属性',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统配置';

-- ----------------------------
-- Records of config
-- ----------------------------
BEGIN;
INSERT INTO `config` VALUES (1, 'name', 'basic', '站点名称', '请填写站点名称', 'string', 'WechatFans', '', 'required', '');
INSERT INTO `config` VALUES (2, 'beian', 'basic', '备案号', '粤ICP备15054802号-4', 'string', '', '', '', '');
INSERT INTO `config` VALUES (3, 'cdnurl', 'basic', 'CDN地址', '如果使用CDN云储存请配置该值', 'string', '', '', '', '');
INSERT INTO `config` VALUES (4, 'version', 'basic', '版本号', '如果静态资源有变动请重新配置该值', 'string', '1.0.1', '', 'required', '');
INSERT INTO `config` VALUES (5, 'timezone', 'basic', '时区', '', 'string', 'Asia/Shanghai', '', 'required', '');
INSERT INTO `config` VALUES (6, 'forbiddenip', 'basic', '禁止访问IP', '一行一条记录', 'text', '', '', '', '');
INSERT INTO `config` VALUES (7, 'languages', 'basic', '模块语言', '', 'array', '{\"backend\":\"zh-cn\",\"frontend\":\"zh-cn\"}', '', 'required', '');
INSERT INTO `config` VALUES (8, 'fixedpage', 'basic', '后台默认页', '请尽量输入左侧菜单栏存在的链接', 'string', 'dashboard', '', 'required', '');
INSERT INTO `config` VALUES (9, 'categorytype', 'dictionary', '分类类型', '', 'array', '{\"default\":\"默认\",\"page\":\"单页\",\"article\":\"文章\",\"test\":\"测试\"}', '', '', '');
INSERT INTO `config` VALUES (10, 'configgroup', 'dictionary', '配置分组', '', 'array', '{\"basic\":\"基础配置\",\"email\":\"邮件配置\",\"dictionary\":\"字典配置\",\"user\":\"会员配置\",\"example\":\"示例分组\"}', '', '', '');
INSERT INTO `config` VALUES (11, 'mail_type', 'email', '邮件发送方式', '选择邮件发送方式', 'select', '1', '[\"请选择\",\"SMTP\",\"mail()函数\"]', '', '');
INSERT INTO `config` VALUES (12, 'mail_smtp_host', 'email', 'SMTP[服务器]', '错误的配置发送邮件会导致服务器超时', 'string', 'smtp.qq.com', '', '', '');
INSERT INTO `config` VALUES (13, 'mail_smtp_port', 'email', 'SMTP[端口]', '(不加密默认25,SSL默认465,TLS默认587)', 'string', '465', '', '', '');
INSERT INTO `config` VALUES (14, 'mail_smtp_user', 'email', 'SMTP[用户名]', '（填写完整用户名）', 'string', '10000', '', '', '');
INSERT INTO `config` VALUES (15, 'mail_smtp_pass', 'email', 'SMTP[密码]', '（填写您的密码）', 'string', 'password', '', '', '');
INSERT INTO `config` VALUES (16, 'mail_verify_type', 'email', 'SMTP验证方式', '（SMTP验证方式[推荐SSL]）', 'select', '2', '[\"无\",\"TLS\",\"SSL\"]', '', '');
INSERT INTO `config` VALUES (17, 'mail_from', 'email', '发件人邮箱', '', 'string', '10000@qq.com', '', '', '');
INSERT INTO `config` VALUES (18, 'audio_profile', 'basic', '资料语音提示', '', 'string', ' ', ' ', '', '');
COMMIT;

-- ----------------------------
-- Table structure for crontab
-- ----------------------------
DROP TABLE IF EXISTS `crontab`;
CREATE TABLE `crontab` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `type` varchar(10) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '事件类型',
  `title` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '事件标题',
  `content` text COLLATE utf8mb4_bin NOT NULL COMMENT '事件内容',
  `schedule` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT 'Crontab格式',
  `sleep` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '延迟秒数执行',
  `maximums` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大执行次数 0为不限',
  `executes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '已经执行的次数',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `begintime` int(10) NOT NULL DEFAULT '0' COMMENT '开始时间',
  `endtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '结束时间',
  `executetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后执行时间',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
  `status` enum('completed','expired','hidden','normal') COLLATE utf8mb4_bin NOT NULL DEFAULT 'normal' COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='定时任务表';

-- ----------------------------
-- Records of crontab
-- ----------------------------
BEGIN;
INSERT INTO `crontab` VALUES (1, 'url', '持久化缓存数据库', '/api/crontab/table', '* * * * *', 0, 0, 73031, 1497070825, 1508832661, 1483761650, 1577868960, 1508832661, 0, 'normal');
INSERT INTO `crontab` VALUES (3, 'url', '异步执行活动后置', '/api/crontab/execute', '* * * * *', 0, 0, 73031, 1497070825, 1508832661, 1483761650, 1598087097, 1508832661, 0, 'normal');
INSERT INTO `crontab` VALUES (5, 'url', '现场结束后置', '/api/crontab/live', '* * * * *', 0, 0, 73031, 1503998066, 1508832661, 1503998043, 1609406048, 1508832661, 0, 'normal');
INSERT INTO `crontab` VALUES (6, 'url', '清理日志目录', '/api/crontab/clear_log', '30 3 */2 * *', 0, 0, 19, 1505445334, 1508700601, 1505445310, 1514690116, 1508700601, 0, 'normal');
COMMIT;

-- ----------------------------
-- Table structure for form_prop
-- ----------------------------
DROP TABLE IF EXISTS `form_prop`;
CREATE TABLE `form_prop` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `type` enum('profile','review') CHARACTER SET latin1 DEFAULT NULL COMMENT '属性类型',
  `name` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '属性名',
  `create_time` int(10) DEFAULT NULL,
  `update_time` int(10) DEFAULT NULL,
  `delete_time` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='表单 - 属性表';

-- ----------------------------
-- Records of form_prop
-- ----------------------------
BEGIN;
INSERT INTO `form_prop` VALUES (1, 'profile', '基础证件:', NULL, NULL, NULL);
INSERT INTO `form_prop` VALUES (2, 'profile', '经营证明：', NULL, NULL, NULL);
INSERT INTO `form_prop` VALUES (3, 'profile', '财力证明：', NULL, NULL, NULL);
INSERT INTO `form_prop` VALUES (4, 'profile', '银行流水：', NULL, NULL, NULL);
INSERT INTO `form_prop` VALUES (5, 'profile', '抵质押权属证明：', NULL, NULL, NULL);
INSERT INTO `form_prop` VALUES (6, 'profile', '贷款用途：', NULL, NULL, NULL);
INSERT INTO `form_prop` VALUES (7, 'profile', '首付款支付凭证：', NULL, NULL, NULL);
INSERT INTO `form_prop` VALUES (8, 'review', '您是从事什么工作的？', NULL, NULL, NULL);
INSERT INTO `form_prop` VALUES (9, 'review', '您干这行多久了？', NULL, NULL, NULL);
INSERT INTO `form_prop` VALUES (10, 'review', '您的房产情况（包括子女、父母、配偶）', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for form_propvalue
-- ----------------------------
DROP TABLE IF EXISTS `form_propvalue`;
CREATE TABLE `form_propvalue` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `type` enum('profile','review') CHARACTER SET latin1 DEFAULT NULL COMMENT '属性类型',
  `prop_id` int(11) unsigned DEFAULT '0',
  `prop_value` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '属性名',
  `create_time` int(10) DEFAULT NULL,
  `update_time` int(10) DEFAULT NULL,
  `delete_time` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='表单 - 属性表';

-- ----------------------------
-- Records of form_propvalue
-- ----------------------------
BEGIN;
INSERT INTO `form_propvalue` VALUES (1, 'review', 8, '公务员和行政事业单位从业人员', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (2, 'review', 9, '0-2年', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (4, 'review', 8, '国有垄断高收入行业员工', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (5, 'profile', 1, '户口本（借款人及配偶、共同借款人及配偶、保证人、抵押人及配偶）', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (6, 'profile', 1, '婚姻证明（借款人、共同借款人、抵押人）', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (7, 'profile', 1, '本地居住和工作证明', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (8, 'profile', 2, '经营实体组织机构代码证（或统一社会信用代码的营业执照）', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (9, 'profile', 2, '经营实体营业执照', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (10, 'profile', 2, '股东会决议及法定代表人出具的实际控制人证明', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (11, 'profile', 2, '近3个月水费、电费单', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (12, 'profile', 2, '借款人/配偶支付的租金证明或水电费单', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (13, 'profile', 3, '资产证明（借款人及配偶，共同借款人及配偶，保证人）', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (14, 'profile', 3, '收入证明（如租金、优质单位收入证明、保证人工作证明等）', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (15, 'profile', 4, '您/您的配偶/您的经营实体近6个月银行流水', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (16, 'profile', 4, '您/您的配偶在我行近6个月或12个月结算账户流水', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (17, 'profile', 4, '您/您的配偶/您的经营实体在我行的POS回款账户近6个月流水', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (18, 'profile', 4, '您/您的配偶/保证人近6个月银行流水', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (19, 'profile', 4, '借款人/配偶信用卡近6个月对账单', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (20, 'profile', 5, '抵押物权属证明（含共有人房产证）', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (21, 'profile', 5, '质押物凭证', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (22, 'profile', 6, '贷款用途材料（购销合同、采购定单、发票等之一）', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (23, 'profile', 6, '原贷款借款及抵押合同、还款清单', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (24, 'profile', 6, '购房合同、首付款凭证', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (25, 'profile', 1, '身份证件（借款人及配偶，共同借款人及配偶，保证人，抵押人及配偶）', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (26, 'profile', 1, '本地户籍/本地居民证明（含水电费单、电话费单等）', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (27, 'profile', 3, '收入证明（借款人，配偶，共同借款人及配偶，保证人）', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (28, 'profile', 3, '与车位同一楼盘的房产证明', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (29, 'profile', 3, '近12个月累计公积金/社保缴存证明', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (30, 'profile', 4, '您/您的配偶近6个月银行流水', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (31, 'profile', 4, '您在我行/他行代发工资账户近6个月/12个月流水', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (32, 'profile', 4, '您/您的配偶信用卡近6个月对账单', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (33, 'profile', 6, '装修', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (34, 'profile', 6, '旅游', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (35, 'profile', 6, '购物', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (36, 'profile', 6, '其他', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (37, 'profile', 3, '公积金账号', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (38, 'profile', 7, '首付款收据', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (39, 'profile', 7, '税控发票', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (40, 'profile', 7, '二手楼资金监管凭证', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (41, 'profile', 7, 'POS单/转账凭证', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (42, 'profile', 7, '首付银行流水', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (43, 'review', 8, '医生', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (44, 'review', 8, '金融', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (45, 'review', 8, '教师', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (46, 'review', 8, '私企老板', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (47, 'review', 8, '私企员工', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (48, 'review', 9, '2-3年', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (49, 'review', 9, '3年以上', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (50, 'review', 10, '本地有房(按揭中)', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (51, 'review', 10, '本地有房(无按揭)', NULL, NULL, NULL);
INSERT INTO `form_propvalue` VALUES (52, 'review', 10, '本地无房', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `title` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '商品标题',
  `album` text COLLATE utf8mb4_bin NOT NULL COMMENT '商品图册',
  `ads` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '广告语',
  `point` int(10) unsigned NOT NULL COMMENT '所需积分',
  `stock` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '可用库存',
  `type` enum('0','1') COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '类型（0：实物；1：虚拟）',
  `attrs` text COLLATE utf8mb4_bin NOT NULL COMMENT '属性集合',
  `content` text COLLATE utf8mb4_bin NOT NULL,
  `use_customer` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '客户经理是否可兑换（0：不可；1：可以）',
  `sort` int(10) unsigned NOT NULL DEFAULT '100' COMMENT '排序字段',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态（0：下架；1：正常）',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0',
  `delete_time` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='商品 - 信息表';

-- ----------------------------
-- Records of goods
-- ----------------------------
BEGIN;
INSERT INTO `goods` VALUES (1, '测试虚拟商品', '[\"http://b.hiphotos.baidu.com/image/pic/item/08f790529822720e0dfee23072cb0a46f31fabc3.jpg\",\"http://e.hiphotos.baidu.com/image/h%3D300/sign=ba8004f7b2014a909e3e40bd99763971/21a4462309f790523cb5fc7b07f3d7ca7acbd5c9.jpg\",\"http://g.hiphotos.baidu.com/image/pic/item/7aec54e736d12f2ee7ed822044c2d56284356881.jpg\"]', '这里就是后台的广告语', 1200, 500, '1', '[]', '测试', 1, 100, 1, 0, 1513227932, NULL);
INSERT INTO `goods` VALUES (6, '测试实物商品1', '', '广告语在这里', 200, 20, '1', '[]', '', 1, 100, 1, 0, 0, NULL);
INSERT INTO `goods` VALUES (9, '测试实物商品2', '', 'www33', 533, 1043, '0', '[]', 'rrrrr63', 1, 3373, 1, 1513210502, 1513751435, NULL);
COMMIT;

-- ----------------------------
-- Table structure for goods_order
-- ----------------------------
DROP TABLE IF EXISTS `goods_order`;
CREATE TABLE `goods_order` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `order_no` varchar(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `nickname` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '用户昵称',
  `goods_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品ID',
  `goods_title` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '商品标题',
  `goods_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '商品类型',
  `number` smallint(6) unsigned NOT NULL DEFAULT '1' COMMENT '兑换数量',
  `points` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '消费积分',
  `address` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '收货地址',
  `mobile` varchar(15) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '联系电话',
  `realname` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '联系姓名',
  `delivery_name` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '物流名称',
  `delivery_sn` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '物流单号',
  `stage` tinyint(2) NOT NULL DEFAULT '0' COMMENT '订单阶段（-1：已取消；0：待确认；1：待发货；2：待收货；99：已完成）',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态(-1：已取消；0：进行中；1：已完成)',
  `confim_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '确认时间',
  `delivery_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发货时间',
  `finsh_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '完成时间',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `cancel_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '取消时间',
  `update_time` int(10) unsigned NOT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='商品 - 订单表';

-- ----------------------------
-- Records of goods_order
-- ----------------------------
BEGIN;
INSERT INTO `goods_order` VALUES (1, 'G20180101223546527390', 3, '朱博', 9, '测试实物商品2', 0, 1, 533, '', '', '', '', '', 0, 0, 0, 0, 0, 1514817346, 0, 1514817346, NULL);
INSERT INTO `goods_order` VALUES (2, 'G20180101223939689570', 3, '朱博', 9, '测试实物商品2', 0, 1, 533, '', '', '', '', '', 0, 0, 0, 0, 0, 1514817579, 0, 1514817579, NULL);
INSERT INTO `goods_order` VALUES (3, 'G20180101224127561027', 3, '朱博', 9, '测试实物商品2', 0, 1, 533, '', '', '', '', '', 0, 0, 0, 0, 0, 1514817687, 0, 1514817687, NULL);
COMMIT;

-- ----------------------------
-- Table structure for goods_order_trace
-- ----------------------------
DROP TABLE IF EXISTS `goods_order_trace`;
CREATE TABLE `goods_order_trace` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `uid` int(11) NOT NULL COMMENT '目标用户',
  `order_no` varchar(30) CHARACTER SET latin1 NOT NULL COMMENT '订单编号',
  `type` char(20) COLLATE utf8mb4_bin NOT NULL COMMENT '操作类型',
  `name` varchar(255) CHARACTER SET latin1 NOT NULL COMMENT '谁操作的',
  `content` varchar(255) CHARACTER SET latin1 NOT NULL COMMENT '追踪内容',
  `issystem` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否系统操作',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0',
  `delete_time` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='商品 - 订单 - 追踪表';

-- ----------------------------
-- Records of goods_order_trace
-- ----------------------------
BEGIN;
INSERT INTO `goods_order_trace` VALUES (1, 0, 'G20180101223546527390', 'create', '', '', 0, 1514817346, 1514817346, NULL);
INSERT INTO `goods_order_trace` VALUES (2, 0, 'G20180101223939689570', 'create', '', '', 0, 1514817579, 1514817579, NULL);
INSERT INTO `goods_order_trace` VALUES (3, 0, 'G20180101224127561027', 'create', '', '', 0, 1514817687, 1514817687, NULL);
COMMIT;

-- ----------------------------
-- Table structure for goods_stock
-- ----------------------------
DROP TABLE IF EXISTS `goods_stock`;
CREATE TABLE `goods_stock` (
  `id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
  `create_time` int(10) unsigned NOT NULL DEFAULT '0',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0',
  `delete_time` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='商品 - 库存管理';

-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `to` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '发送给谁？（0为所有；否则为对应uid）',
  `from` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '谁发出的？（0为系统，否则为对应uid）',
  `role` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '接收者角色',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0',
  `delete_time` int(10) DEFAULT NULL,
  `title` char(200) COLLATE utf8mb4_bin NOT NULL,
  `content` text COLLATE utf8mb4_bin,
  `order_sn` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '贷款订单号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户 - 抢单表';

-- ----------------------------
-- Table structure for notify
-- ----------------------------
DROP TABLE IF EXISTS `notify`;
CREATE TABLE `notify` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `type` enum('sms','wechat') COLLATE utf8mb4_bin NOT NULL COMMENT '通知类型',
  `to` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '接收者',
  `title` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '标题',
  `content` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '内容',
  `templateid` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '模板ID',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '发送状态',
  `result` tinyint(1) NOT NULL DEFAULT '0' COMMENT '接收状态',
  `create_time` int(10) NOT NULL COMMENT '创建时间',
  `update_time` int(10) NOT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户表';

-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `brief` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `sort` smallint(6) unsigned NOT NULL DEFAULT '100',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态（0：下架；1：正常）',
  `customer_point` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '贷款成功客户经理所得积分',
  `distributor_point` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '分销商所得积分',
  `question_template_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '初核问卷模板ＩＤ',
  `profile_template_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '贷款资料模板ID',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0',
  `delete_time` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='产品 - 信息表';

-- ----------------------------
-- Records of product
-- ----------------------------
BEGIN;
INSERT INTO `product` VALUES (1, '小微贷款', '只要您有家有房有经营，即可申请生意备用金，最高500万，一次授信，可循环使用，用一天算一天利息，不用不收息。', 100, 1, 10000, 2000, 1, 1, 0, 1514816704, NULL);
INSERT INTO `product` VALUES (3, '消费贷款', '您无需等待，如果您要出国、装修、旅游等家庭大宗消费，可在此申请家庭消费备用金，一次授信，可循环使用，用一天算一天利息，不用不收息。', 100, 1, 0, 0, 2, 1, 0, 1513835840, NULL);
INSERT INTO `product` VALUES (4, '住房贷款', '您在这里可以申请用于购房的按揭贷款，还可享受招行专享团购优惠。', 100, 1, 0, 0, 3, 1, 0, 1513835901, NULL);
COMMIT;

-- ----------------------------
-- Table structure for product_order
-- ----------------------------
DROP TABLE IF EXISTS `product_order`;
CREATE TABLE `product_order` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `sn` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '订单号',
  `product_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '产品ID',
  `question_template_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '初核问卷模板ID',
  `question_result_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '初核问卷答案ID',
  `profile_template_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '资料清单模板ID',
  `customer_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '客户经理ID',
  `customer_point` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '客户经理应获积分',
  `distributor_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分销商ID',
  `distributor_point` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '分销商应获积分',
  `source` enum('apply','invite') COLLATE utf8mb4_bin NOT NULL DEFAULT 'apply' COMMENT '订单来源',
  `realname` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '姓名',
  `mobile` char(15) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '手机',
  `stage` tinyint(2) NOT NULL DEFAULT '0' COMMENT '阶段（-99：贷款审核失败；-1：未通过初核；0：准备资料；1：待经理联系；2：待客户确认；3：待经理上报；4：待系统审核；99：贷款已通过）',
  `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '状态（-1：已撤销；0：进行中；1：已完成）',
  `reserve_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '首次抢单时间',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='产品 - 订单表';

-- ----------------------------
-- Records of product_order
-- ----------------------------
BEGIN;
INSERT INTO `product_order` VALUES (1, 2, 'D20171228152127182403', 1, 1, 1, 1, 1, 10000, 0, 2000, 'apply', '董浩', '13108807733', 0, 0, 1514467301, 1514445687, 1514476245, NULL);
INSERT INTO `product_order` VALUES (2, 3, 'D20171228162331917628', 1, 1, 2, 1, 0, 10000, 0, 2000, 'apply', '朱博', '13099964653', -1, 1, 0, 1514449411, 1514449411, NULL);
INSERT INTO `product_order` VALUES (3, 3, 'D20171228162515269058', 1, 1, 3, 1, 0, 10000, 0, 2000, 'apply', '朱博', '13099964653', 0, 0, 0, 1514449515, 1514449515, NULL);
INSERT INTO `product_order` VALUES (4, 4, 'D20171228162653471392', 1, 1, 4, 1, 0, 10000, 0, 2000, 'apply', '刘鹏', '13888045176', 0, 0, 1514536019, 1514449613, 1514449613, NULL);
INSERT INTO `product_order` VALUES (5, 11, 'D20171228175702642380', 1, 1, 5, 1, 14, 10000, 0, 2000, 'apply', '许', '18313874887', 0, 0, 1514535950, 1514455022, 1514536019, NULL);
INSERT INTO `product_order` VALUES (6, 5, 'D20171229140935802135', 3, 2, 6, 1, 14, 0, 0, 0, 'apply', '杨蓉', '15877981279', 0, 0, 1514529055, 1514527775, 1514529471, NULL);
INSERT INTO `product_order` VALUES (7, 12, 'D20171229164102476183', 1, 1, 7, 1, 0, 10000, 0, 2000, 'apply', '梁晨', '13099928760', -1, 1, 0, 1514536862, 1514536862, NULL);
INSERT INTO `product_order` VALUES (8, 12, 'D20171229164207209736', 3, 2, 8, 1, 0, 0, 0, 0, 'apply', '梁晨', '13099928760', 0, 0, 0, 1514536927, 1514536927, NULL);
COMMIT;

-- ----------------------------
-- Table structure for product_order_reserve
-- ----------------------------
DROP TABLE IF EXISTS `product_order_reserve`;
CREATE TABLE `product_order_reserve` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `order_sn` varchar(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '订单号',
  `order_uid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '订单用户',
  `customer_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '预定客户经理ID',
  `weight` decimal(4,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '预定时权重',
  `result` tinyint(1) NOT NULL DEFAULT '0' COMMENT '抢单结果（-1：失败；0：抢单中；1：成功）',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0',
  `delete_time` int(10) DEFAULT NULL,
  `product_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '产品ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='订单- 抢单表';

-- ----------------------------
-- Records of product_order_reserve
-- ----------------------------
BEGIN;
INSERT INTO `product_order_reserve` VALUES (1, 'D20171228152127182403', 2, 3, 0.00, 1, 1514467301, 1514476245, NULL, 1);
INSERT INTO `product_order_reserve` VALUES (2, 'D20171229140935802135', 5, 14, 0.00, 1, 1514529055, 1514529398, NULL, 3);
INSERT INTO `product_order_reserve` VALUES (3, 'D20171228162653471392', 4, 14, 0.00, 1, 1514535950, 1514536019, NULL, 1);
INSERT INTO `product_order_reserve` VALUES (4, 'D20171229140935802135', 5, 10, 0.00, 0, 1514537355, 1514537355, NULL, 3);
COMMIT;

-- ----------------------------
-- Table structure for product_order_trace
-- ----------------------------
DROP TABLE IF EXISTS `product_order_trace`;
CREATE TABLE `product_order_trace` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `order_sn` varchar(100) CHARACTER SET latin1 NOT NULL COMMENT '订单号',
  `action_uid` int(11) NOT NULL DEFAULT '0' COMMENT '操作者',
  `content` text COLLATE utf8mb4_bin NOT NULL,
  `create_time` int(10) unsigned NOT NULL,
  `update_time` int(10) unsigned NOT NULL,
  `delete_time` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `order_sn` (`order_sn`) USING BTREE COMMENT '订单号'
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='产品 - 订单 - 跟踪表';

-- ----------------------------
-- Records of product_order_trace
-- ----------------------------
BEGIN;
INSERT INTO `product_order_trace` VALUES (1, 'D20171228152127182403', 2, '初核通过，待客户经理首次联系', 1514445687, 1514445687, NULL);
INSERT INTO `product_order_trace` VALUES (2, 'D20171228162331917628', 3, '初核失败', 1514449411, 1514449411, NULL);
INSERT INTO `product_order_trace` VALUES (3, 'D20171228162515269058', 3, '初核通过，待客户经理首次联系', 1514449516, 1514449516, NULL);
INSERT INTO `product_order_trace` VALUES (4, 'D20171228162653471392', 4, '初核通过，待客户经理首次联系', 1514449613, 1514449613, NULL);
INSERT INTO `product_order_trace` VALUES (5, 'D20171228175702642380', 11, '初核通过，待客户经理首次联系', 1514455022, 1514455022, NULL);
INSERT INTO `product_order_trace` VALUES (6, 'D20171229140935802135', 5, '初核通过，待客户经理首次联系', 1514527775, 1514527775, NULL);
INSERT INTO `product_order_trace` VALUES (7, 'D20171229140935802135', 14, '客户经理已完成首次联系，待客户确认', 1514529410, 1514529410, NULL);
INSERT INTO `product_order_trace` VALUES (8, 'D20171229140935802135', 14, '客户经理已完成首次联系，待客户确认', 1514529470, 1514529470, NULL);
INSERT INTO `product_order_trace` VALUES (9, 'D20171229140935802135', 14, '客户经理已完成首次联系，待客户确认', 1514529471, 1514529471, NULL);
INSERT INTO `product_order_trace` VALUES (10, 'D20171229164102476183', 12, '初核失败', 1514536862, 1514536862, NULL);
INSERT INTO `product_order_trace` VALUES (11, 'D20171229164207209736', 12, '初核通过，待客户经理首次联系', 1514536927, 1514536927, NULL);
COMMIT;

-- ----------------------------
-- Table structure for product_order_transfer
-- ----------------------------
DROP TABLE IF EXISTS `product_order_transfer`;
CREATE TABLE `product_order_transfer` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `order_sn` varchar(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '订单号',
  `touid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '转交给谁',
  `formuid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '谁转交的',
  `result` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态（-1：拒绝；0:待处理；1:已接收）',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0',
  `delete_time` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='订单- 转交表';

-- ----------------------------
-- Table structure for profile_template
-- ----------------------------
DROP TABLE IF EXISTS `profile_template`;
CREATE TABLE `profile_template` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `title` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '模板标题',
  `content` text COLLATE utf8mb4_bin NOT NULL COMMENT '模板内容',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  `product_id` int(11) NOT NULL COMMENT '所属产品',
  `owner_aid` int(11) NOT NULL COMMENT '创建者',
  `is_system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否系统创建',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='资料 - 模板表';

-- ----------------------------
-- Records of profile_template
-- ----------------------------
BEGIN;
INSERT INTO `profile_template` VALUES (1, '小微贷款资料模板', '{\"1\":[25,5,6,7],\"2\":[8,9,10,11,12],\"3\":[13,14],\"4\":[15,16,17,18,19],\"5\":[20,21],\"6\":[22,23,24]}', 1, 0, 1, 1, 0, 0, NULL);
INSERT INTO `profile_template` VALUES (2, '消费贷款资料模板', '', 1, 0, 1, 1, 0, 0, NULL);
INSERT INTO `profile_template` VALUES (3, '小微贷款', '{\"1\":[\"6\",\"5\"]}', 0, 0, 18, 0, 1513799883, 1513799883, NULL);
INSERT INTO `profile_template` VALUES (4, '小微贷款', '{\"1\":[\"6\"]}', 0, 0, 18, 0, 1513800146, 1513800146, NULL);
INSERT INTO `profile_template` VALUES (5, '小微贷款', '{\"1\":[\"5\",\"6\"]}', 0, 0, 18, 0, 1513800347, 1513800347, NULL);
INSERT INTO `profile_template` VALUES (6, '小微贷款', '{\"1\":[\"5\",\"6\"]}', 0, 0, 18, 0, 1513800362, 1513800362, NULL);
INSERT INTO `profile_template` VALUES (7, '小微贷款', '{\"2\":[\"8\"]}', 0, 0, 18, 0, 1513800388, 1513800388, NULL);
INSERT INTO `profile_template` VALUES (8, '小微贷款', '{\"2\":[\"9\",\"8\"]}', 0, 0, 18, 0, 1513800633, 1513800633, NULL);
INSERT INTO `profile_template` VALUES (9, '小微贷款', '{\"2\":[\"9\",\"8\"]}', 0, 0, 18, 0, 1513800671, 1513800671, NULL);
INSERT INTO `profile_template` VALUES (10, '小微贷款', '{\"2\":[\"9\",\"8\"]}', 0, 0, 18, 0, 1513800728, 1513800728, NULL);
INSERT INTO `profile_template` VALUES (11, '小微贷款', '{\"1\":[\"6\",\"5\"]}', 0, 0, 18, 0, 1513800775, 1513800775, NULL);
INSERT INTO `profile_template` VALUES (12, '小微贷款', '{\"1\":[\"5\",\"6\"]}', 0, 0, 18, 0, 1513801063, 1513801063, NULL);
INSERT INTO `profile_template` VALUES (13, '小微贷款', '{\"1\":[\"5\",\"6\"]}', 0, 0, 18, 0, 1513801070, 1513801070, NULL);
INSERT INTO `profile_template` VALUES (14, '小微贷款', '{\"2\":[\"9\"]}', 0, 0, 18, 0, 1513801099, 1513801099, NULL);
INSERT INTO `profile_template` VALUES (15, '小微贷款', '{\"1\":[\"5\",\"6\"]}', 0, 0, 18, 0, 1513801198, 1513801198, NULL);
INSERT INTO `profile_template` VALUES (16, '小微贷款', '{\"1\":[\"5\",\"6\"]}', 0, 0, 18, 0, 1513801225, 1513801225, NULL);
INSERT INTO `profile_template` VALUES (17, '小微贷款', '{\"1\":[\"5\",\"6\",\"7\",\"25\"],\"2\":[\"8\",\"10\",\"9\",\"11\",\"12\"],\"3\":[\"13\",\"14\"],\"4\":[\"15\",\"17\",\"16\",\"18\",\"19\"],\"5\":[\"20\",\"21\"],\"6\":[\"22\",\"23\",\"24\"]}', 0, 0, 21, 0, 1513836717, 1513836717, NULL);
INSERT INTO `profile_template` VALUES (18, '小微贷款', '{\"1\":[\"5\",\"6\",\"7\",\"25\"],\"2\":[\"8\",\"9\",\"10\",\"11\",\"12\"],\"3\":[\"13\",\"14\"],\"4\":[\"16\",\"15\",\"17\",\"18\",\"19\"],\"5\":[\"20\",\"21\"],\"6\":[\"22\",\"23\",\"24\"]}', 0, 0, 20, 0, 1513836758, 1513836758, NULL);
INSERT INTO `profile_template` VALUES (19, '小微贷款', '{\"1\":[\"5\",\"6\",\"7\",\"25\"],\"2\":[\"8\",\"10\",\"9\",\"11\",\"12\"],\"3\":[\"13\",\"14\"],\"4\":[\"15\",\"17\",\"16\",\"18\",\"19\"],\"5\":[\"20\",\"21\"],\"6\":[\"22\",\"23\",\"24\"]}', 0, 0, 21, 0, 1513836808, 1513836808, NULL);
INSERT INTO `profile_template` VALUES (20, '小微贷款', '{\"1\":[\"5\",\"25\",\"6\",\"7\"],\"2\":[\"8\",\"9\",\"10\",\"11\",\"12\"],\"3\":[\"13\",\"14\"],\"4\":[\"15\",\"16\",\"17\",\"19\",\"18\"],\"5\":[\"20\",\"21\"],\"6\":[\"22\",\"23\",\"24\"]}', 0, 0, 20, 0, 1513836823, 1513836823, NULL);
INSERT INTO `profile_template` VALUES (21, '小微贷款', '[]', 0, 0, 18, 0, 1513857898, 1513857898, NULL);
INSERT INTO `profile_template` VALUES (22, '小微贷款', '{\"1\":[\"5\"],\"2\":[\"9\"]}', 0, 0, 18, 0, 1513858086, 1513858086, NULL);
INSERT INTO `profile_template` VALUES (23, '小微贷款', '{\"1\":[\"6\",\"7\",\"5\"],\"3\":[\"14\",\"13\"]}', 0, 0, 18, 0, 1513859138, 1513859138, NULL);
INSERT INTO `profile_template` VALUES (24, '小微贷款', '{\"1\":[\"7\",\"6\",\"5\"],\"3\":[\"14\",\"13\"]}', 0, 0, 18, 0, 1513866876, 1513866876, NULL);
INSERT INTO `profile_template` VALUES (25, '小微贷款', '{\"1\":[\"6\",\"5\"]}', 0, 0, 18, 0, 1513876522, 1513876522, NULL);
INSERT INTO `profile_template` VALUES (26, '小微贷款', '{\"1\":[\"6\",\"5\"]}', 0, 0, 18, 0, 1513876524, 1513876524, NULL);
INSERT INTO `profile_template` VALUES (27, '小微贷款', '{\"1\":[\"6\",\"5\"]}', 0, 0, 18, 0, 1513876524, 1513876524, NULL);
INSERT INTO `profile_template` VALUES (28, '小微贷款', '{\"1\":[\"6\",\"5\"]}', 0, 0, 18, 0, 1513876525, 1513876525, NULL);
INSERT INTO `profile_template` VALUES (29, '小微贷款', '{\"1\":[\"6\",\"5\"]}', 0, 0, 18, 0, 1513876525, 1513876525, NULL);
INSERT INTO `profile_template` VALUES (30, '住房贷款', '{\"1\":[\"6\"]}', 0, 4, 18, 0, 1514168131, 1514168131, NULL);
INSERT INTO `profile_template` VALUES (31, '小微贷款', '{\"1\":[\"6\",\"5\"]}', 0, 1, 18, 0, 1514168262, 1514168262, NULL);
INSERT INTO `profile_template` VALUES (32, '小微贷款', '{\"1\":[\"5\",\"6\"]}', 0, 1, 18, 0, 1514168292, 1514168292, NULL);
INSERT INTO `profile_template` VALUES (33, '小微贷款', '{\"1\":[\"6\",\"5\"]}', 0, 1, 18, 0, 1514168457, 1514168457, NULL);
INSERT INTO `profile_template` VALUES (34, '小微贷款', '{\"1\":[\"5\"]}', 0, 1, 18, 0, 1514168558, 1514168558, NULL);
INSERT INTO `profile_template` VALUES (35, '小微贷款', '{\"1\":[\"5\",\"6\"]}', 0, 1, 18, 0, 1514168591, 1514168591, NULL);
INSERT INTO `profile_template` VALUES (36, '小微贷款', '{\"1\":[\"5\",\"6\",\"7\",\"25\"]}', 0, 1, 21, 0, 1514170061, 1514170061, NULL);
INSERT INTO `profile_template` VALUES (37, '消费贷款', '{\"1\":[\"5\",\"6\",\"25\",\"7\"],\"3\":[\"14\",\"13\"],\"4\":[\"18\"],\"5\":[\"20\"]}', 0, 3, 10, 0, 1514537473, 1514537473, NULL);
INSERT INTO `profile_template` VALUES (38, '小微贷款', '{\"1\":[\"5\",\"6\",\"7\",\"25\"]}', 0, 1, 10, 0, 1514541597, 1514541597, NULL);
INSERT INTO `profile_template` VALUES (39, '小微贷款', '{\"1\":[\"5\",\"6\",\"7\",\"25\"],\"2\":[\"8\",\"9\",\"10\",\"11\",\"12\"],\"3\":[\"13\"],\"4\":[\"17\"],\"5\":[\"20\"],\"6\":[\"22\"]}', 0, 1, 10, 0, 1514541615, 1514541615, NULL);
COMMIT;

-- ----------------------------
-- Table structure for question_result
-- ----------------------------
DROP TABLE IF EXISTS `question_result`;
CREATE TABLE `question_result` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `product_id` int(10) NOT NULL COMMENT '产品ID',
  `user_id` int(10) NOT NULL COMMENT '会员ID',
  `content` text COLLATE utf8mb4_bin NOT NULL COMMENT '问答合集',
  `result` tinyint(1) NOT NULL DEFAULT '0' COMMENT '问答结果',
  `create_time` int(10) NOT NULL COMMENT '创建时间',
  `update_time` int(10) NOT NULL COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='答案 - 结果表';

-- ----------------------------
-- Records of question_result
-- ----------------------------
BEGIN;
INSERT INTO `question_result` VALUES (1, 1, 2, '{\"您是从事什么工作的？\":\"私企老板\",\"您干这行多久了？\":\"3年以上\",\"您的房产情况（包括子女、父母、配偶）\":\"本地有房(按揭中)\"}', 1, 1514445687, 1514445687, NULL);
INSERT INTO `question_result` VALUES (2, 1, 3, '{\"您是从事什么工作的？\":\"医生\"}', 0, 1514449411, 1514449411, NULL);
INSERT INTO `question_result` VALUES (3, 1, 3, '{\"您是从事什么工作的？\":\"私企老板\",\"您干这行多久了？\":\"2-3年\",\"您的房产情况（包括子女、父母、配偶）\":\"本地有房(无按揭)\"}', 1, 1514449515, 1514449515, NULL);
INSERT INTO `question_result` VALUES (4, 1, 4, '{\"您是从事什么工作的？\":\"私企老板\",\"您干这行多久了？\":\"3年以上\",\"您的房产情况（包括子女、父母、配偶）\":\"本地有房(按揭中)\"}', 1, 1514449613, 1514449613, NULL);
INSERT INTO `question_result` VALUES (5, 1, 11, '{\"您是从事什么工作的？\":\"私企老板\",\"您干这行多久了？\":\"3年以上\",\"您的房产情况（包括子女、父母、配偶）\":\"本地有房(无按揭)\"}', 1, 1514455022, 1514455022, NULL);
INSERT INTO `question_result` VALUES (6, 3, 5, '{\"您是从事什么工作的？\":\"金融\",\"您干这行多久了？\":\"3年以上\",\"您的房产情况（包括子女、父母、配偶）\":\"本地有房(按揭中)\"}', 1, 1514527775, 1514527775, NULL);
INSERT INTO `question_result` VALUES (7, 1, 12, '{\"您是从事什么工作的？\":\"金融\"}', 0, 1514536862, 1514536862, NULL);
INSERT INTO `question_result` VALUES (8, 3, 12, '{\"您是从事什么工作的？\":\"金融\",\"您干这行多久了？\":\"2-3年\",\"您的房产情况（包括子女、父母、配偶）\":\"本地有房(按揭中)\"}', 1, 1514536927, 1514536927, NULL);
COMMIT;

-- ----------------------------
-- Table structure for question_template
-- ----------------------------
DROP TABLE IF EXISTS `question_template`;
CREATE TABLE `question_template` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `title` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `content` text CHARACTER SET utf8mb4 COMMENT '表单内容',
  `status` tinyint(1) unsigned DEFAULT NULL COMMENT '状态',
  `rules` text CHARACTER SET utf8mb4 COMMENT '模板规则，以JSON形式存储其组合实体定义。如：\n@value.id\n@value.id && value.id[2]\n@value.id && value.id[2] …',
  `create_aid` int(10) unsigned DEFAULT NULL,
  `create_time` int(10) DEFAULT NULL,
  `update_time` int(10) DEFAULT NULL,
  `delete_time` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='初核 - 模板表';

-- ----------------------------
-- Records of question_template
-- ----------------------------
BEGIN;
INSERT INTO `question_template` VALUES (1, '小微贷款初核模板', '{\"8\":[1,4,43,44,45,46,47],\"9\":[2,48,49], \"10\":[50,51,52]}', 1, '{\"8.1\":0,\"8.4\":0,\"8.43\":0,\"8.44\":0,\"8.45\":0,\"8.46\":1,\"8.47\":1,\"9.2\":0,\"9.48\":1,\"9.49\":1,\"10.50\":1,\"10.51\":1,\"10.52\":0}', NULL, NULL, NULL, NULL);
INSERT INTO `question_template` VALUES (2, '消费贷款初核模板', '{\"8\":[1,4,43,44,45,46,47],\"9\":[2,48,49], \"10\":[50,51,52]}', 1, '{\"8.1\":1,\"8.4\":1,\"8.43\":1,\"8.44\":1,\"8.45\":0,\"8.46\":0,\"8.47\":0,\"9.2\":0,\"9.48\":1,\"9.49\":1,\"10.50\":1,\"10.51\":1,\"10.52\":1}', NULL, NULL, NULL, NULL);
INSERT INTO `question_template` VALUES (3, '租房贷款初核模板', '{\"8\":[1,4,43,44,45,46,47],\"9\":[2,48,49], \"10\":[50,51,52]}', 1, '{\"8.1\":1,\"8.4\":1,\"8.43\":1,\"8.44\":1,\"8.45\":1,\"8.46\":1,\"8.47\":1,\"9.2\":1,\"9.48\":1,\"9.49\":1,\"10.50\":1,\"10.51\":1,\"10.52\":1}', NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for queue
-- ----------------------------
DROP TABLE IF EXISTS `queue`;
CREATE TABLE `queue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) CHARACTER SET utf8 NOT NULL,
  `payload` longtext CHARACTER SET utf8 NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='消息队列';

-- ----------------------------
-- Records of queue
-- ----------------------------
BEGIN;
INSERT INTO `queue` VALUES (78, 'template_message', '{\"job\":\"app\\\\notification\\\\command\\\\TemplateMessage\",\"data\":{\"touser\":\"obVzzjuFfBfMSmws6klrrFymsldM\",\"template_id\":\"0BRIyWwkahuIDLRYFD0DtIPNQ3eE8iWxXEmiIaWw4sE\",\"data\":false}}', 0, 0, NULL, 1514478053, 1514478053);
INSERT INTO `queue` VALUES (79, 'template_message', '{\"job\":\"app\\\\notification\\\\command\\\\TemplateMessage\",\"data\":{\"touser\":\"obVzzjuFfBfMSmws6klrrFymsldM\",\"template_id\":\"0BRIyWwkahuIDLRYFD0DtIPNQ3eE8iWxXEmiIaWw4sE\",\"data\":false}}', 0, 0, NULL, 1514478104, 1514478104);
INSERT INTO `queue` VALUES (80, 'template_message', '{\"job\":\"app\\\\notification\\\\command\\\\TemplateMessage\",\"data\":{\"touser\":\"obVzzjuFfBfMSmws6klrrFymsldM\",\"template_id\":\"0BRIyWwkahuIDLRYFD0DtIPNQ3eE8iWxXEmiIaWw4sE\",\"data\":false}}', 0, 0, NULL, 1514478391, 1514478391);
INSERT INTO `queue` VALUES (81, 'template_message', '{\"job\":\"app\\\\notification\\\\command\\\\TemplateMessage\",\"data\":{\"touser\":\"obVzzjuFfBfMSmws6klrrFymsldM\",\"template_id\":\"pP6e70v5mwOblhjn7qoTYIP-G1-voa2KIYDCuGG0WNE\",\"url\":\"https:\\/\\/easywechat.org\",\"data\":{\"first\":\"\\u60a8\\u7684\\u5ba2\\u6237\\u7ecf\\u7406\\u5df2\\u786e\\u8ba4\\u9996\\u6b21\\u8054\\u7cfb\",\"keyword1\":\"test1\",\"keyword2\":\"test2\",\"remark\":\"\\u611f\\u8c22\\u60a8\\u7684\\u4f7f\\u7528\"}}}', 0, 0, NULL, 1514536927, 1514536927);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `openid` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `unionid` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `nickname` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `avatar` varchar(200) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `role` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '用户角色（0：普通客户；1：分销商；2：客户经理）',
  `point` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '可用积分',
  `qrcode` varchar(200) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '分销二维码',
  `create_time` int(10) NOT NULL DEFAULT '0',
  `update_time` int(10) NOT NULL DEFAULT '0',
  `delete_time` int(10) DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `gender` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `customer_id` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '关联客户经理ID',
  `distributor_id` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '关联分销商ID',
  `goods_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '兑换总次数',
  `product_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '贷款总次数',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态（0：锁定；1:正常；）',
  `apply_status` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `weight` decimal(4,2) unsigned NOT NULL DEFAULT '0.00',
  `city` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `province` varchar(100) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
  `country` varchar(100) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
  `token` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '通信密钥',
  `customer_code` varchar(6) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '客户经理编码',
  `customer_realname` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '客户经理姓名',
  `customer_pinyin` varchar(10) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '客户经理姓名首字母',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户表';

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'oPnMk0W7KUWkR9Lt1OvoloDwsc8c', 'onJre1GDmtnYkzE9VQyl1NXqoEgQ', '夏雪强', 'https://wx.qlogo.cn/mmopen/vi_32/DYAIOgq83epSS41HXNxoKciaic0EyEXLCibsE4vUHOiaZtpXviaMaKYgonp9h3vfjnmBmsZr6Rxe6iaPNGaZX2bKVn1Q/0', 0, 0, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0W7KUWkR9Lt1OvoloDwsc8c.png', 1514440765, 1514644865, NULL, '', '1', 0, 0, 0, 0, 1, '', 0.00, '垫江', '重庆', '', 'bc16da58-4174-4123-9931-22624e512672', '', '', '');
INSERT INTO `user` VALUES (2, 'oPnMk0QPYq9Xqcf0FuBfjXbqxv08', 'onJre1LXzjG78RK_lYzbmAn6MR6M', '董浩@小折', 'https://wx.qlogo.cn/mmopen/vi_32/9SD6zYToLT1y1jIPJ2U1BWTklpZQbxdd331pjibxPd7TlRzIfmVU0ZkCmX5nSKOHvmfv783GJmmF2VYANkWbnibg/0', 1, 0, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0QPYq9Xqcf0FuBfjXbqxv08.png', 1514441143, 1514441143, NULL, '', '1', 3, 0, 0, 0, 1, '', 0.00, '昆明', '云南', '', '35076b47-4198-4923-8d8a-4688a3799b9a', '', '', '');
INSERT INTO `user` VALUES (3, 'oPnMk0VOQCAGAtheEddLaMBuwEQI', 'onJre1KG-Vx8GkZj9wmVSmXe8zss', '朱博', 'https://wx.qlogo.cn/mmopen/vi_32/S6h3pRIScQtk4bHzicDwsub2QDlxj1cHMsQmppic0Z9x3842TcXniagW1SLfGWI85XnalIRP3W2iaHTTicdal5O2kHg/0', 2, 32933, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0VOQCAGAtheEddLaMBuwEQI.png', 1514441214, 1514520805, NULL, '13099964653', '1', 0, 0, 0, 0, 1, '', 0.00, '南岸', '重庆', '', 'b6bc452a-44be-43a3-a5a9-b0cfff3f3914', '', '', '');
INSERT INTO `user` VALUES (4, 'oPnMk0TJ1Z93CzVl7cdo9qVh7byk', 'onJre1M4uDgXYclVWkmcr-aANXj4', '刘鹏@小折', 'https://wx.qlogo.cn/mmopen/vi_32/c1gfxFuG4ZgSfJG1N4OBAD41OHULQibbuh7ialF0ftw7icRralV1b6m9NFomIurTDzyErszHsibOjOcXWR5M2HRFjg/0', 0, 0, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0TJ1Z93CzVl7cdo9qVh7byk.png', 1514449539, 1514449539, NULL, '', '1', 0, 0, 0, 0, 1, '', 0.00, '昆明', '云南', '', 'ed581811-7d00-407f-a589-4971aba6306c', '', '', '');
INSERT INTO `user` VALUES (5, 'oPnMk0T_pDtlXXVBNYCUPUBQRfJ4', 'onJre1EHygVbHNaV7FtytQ3tGtyc', 'RacheI', 'https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTISxXk0N0vyqreibKvoWqIDvFCFqoZibBkib0KbWibNYRqqIm0NHiccXibhAiaZl7jHibmvp2RDsNzugmTESw/0', 0, 0, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0T_pDtlXXVBNYCUPUBQRfJ4.png', 1514450910, 1514450910, NULL, '', '2', 0, 0, 0, 0, 1, '', 0.00, '昆明', '云南', '', 'f036e10c-cc9a-4bc9-9e3b-10c4a53f487c', '', '', '');
INSERT INTO `user` VALUES (6, 'oPnMk0bPT8omqyZRzx7b3tgIdt04', 'onJre1Idx0I9T2SuAOhIdBDEw2ew', '大鲸', 'https://wx.qlogo.cn/mmopen/vi_32/37sNuJ3IuA77UZq5RqT9HLHbtshweDlVh9csQY5T0sbQa7VYypjD89DdE9PgILiaFZMPGCqeEZZcqEGN1tet0dA/0', 2, 0, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0bPT8omqyZRzx7b3tgIdt04.png', 1514454682, 1514515269, NULL, '15925181731', '2', 0, 0, 0, 0, 1, '', 0.00, 'Zimbabwe', 'Others', '', '04bf98b8-bdd5-44b6-94e7-0f0526be44a4', '004', '杨婧雯', 'y');
INSERT INTO `user` VALUES (7, 'oPnMk0WTM9eYeGnYH5uoiecyZT7k', 'onJre1DlgnGN5CBnXGzfhJ9y27_Q', 'Ling', 'https://wx.qlogo.cn/mmopen/vi_32/xvRCiawRHNqktOxPCSkObIhXBAmgxCYnpwHYC7rHCDCBK4XcIALJ0nLPG7IIaSCR9DvfGRX5XVsoDbdUvcKZGlQ/0', 2, 0, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0WTM9eYeGnYH5uoiecyZT7k.png', 1514454688, 1514515179, NULL, '15925236591', '1', 0, 0, 0, 0, 1, '', 0.00, '昆明', '云南', '', 'fceca4ff-1f41-481d-81e3-0c45aa1ca7dc', '001', '凌艳伟', 'l');
INSERT INTO `user` VALUES (8, 'oPnMk0Tsz6VOtzUHtUuVNFs8ZVLs', 'onJre1KBI1SiFnWXOuZ6YzSpz5Jk', 'de', 'https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLlPdgJhYd1VicOibxRd38MYLptnqKZdcpeoSLfX8tesH9OFiaWUTDeJ4sicibZ9N3KzDFBibKSEQT9hITg/0', 0, 0, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0Tsz6VOtzUHtUuVNFs8ZVLs.png', 1514454698, 1514454698, NULL, '', '1', 0, 0, 0, 0, 1, '', 0.00, '昆明', '云南', '', '629de4a3-3440-47ac-87af-2d3dcedcd21f', '', '', '');
INSERT INTO `user` VALUES (9, 'oPnMk0VE-zQViPJAvDKrjs70lPoU', 'onJre1Mmld7lOL0U-DCS8RXfoO44', '曹相男', 'https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJLnprribRydu3IKIFkQicdvhiakpdibibexcRlT5M1K58R2wIzoOwfXlsQ6pu9eFkLbK4bDW6eeiaWZsXQ/0', 0, 0, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0VE-zQViPJAvDKrjs70lPoU.png', 1514454731, 1514454731, NULL, '', '1', 0, 0, 0, 0, 1, '', 0.00, '昆明', '云南', '', 'b014e087-44f8-43bd-8cd2-da51b1e95711', '', '', '');
INSERT INTO `user` VALUES (10, 'oPnMk0UQDnKZV_y1QUs8jqjy7cl8', 'onJre1LgftOQNeuFAwlyanDVAohE', '车瑾', 'https://wx.qlogo.cn/mmopen/vi_32/ajNVdqHZLLDThHicfIPoMAaAa4RlcJ752HYOnaGs7YMSjo7VicRtlZSNqesy0h4iaTKakZ2oBibB1J8U6OqUAlBFIQ/0', 2, 0, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0UQDnKZV_y1QUs8jqjy7cl8.png', 1514454862, 1514515297, NULL, '13619605216', '2', 0, 0, 0, 0, 1, '', 0.00, '昆明', '云南', '', '8a6cd62d-d3c8-4d1e-add9-8fc7066e9f3e', '002', '车瑾', 'c');
INSERT INTO `user` VALUES (11, 'oPnMk0eGsrg51YsAmzQkiXRjI4ac', 'onJre1MIuGSE7Q72JE4UYKyldhc4', '许文彬', 'https://wx.qlogo.cn/mmopen/vi_32/DYAIOgq83epbRq3gAGUmk2s7ibib6nZyt5IiamYHDmTlGibWJSYO5xRwJQmZS5IS3veGQNBiahkX9yJodeL43gxGpsw/0', 2, 0, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0eGsrg51YsAmzQkiXRjI4ac.png', 1514454948, 1514515333, NULL, '18313874887', '1', 0, 0, 0, 0, 1, '', 0.00, '大理', '云南', '', '60df2fed-b67b-49c5-928b-9e89beb46368', '003', '许文彬', 'x');
INSERT INTO `user` VALUES (12, 'oPnMk0QzSUObZma9DLYSgtiZlAjU', 'onJre1NXZjNsqDYq6Q8igKcJJMTo', '梁大大', 'https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTL9frbmm2rIA5v5OlaLUnhjQFiaXdouKPTapmYrUKcwe1WBeRl840UuXWkN4NjNlRy1xsb8RibbwXcw/0', 0, 0, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0QzSUObZma9DLYSgtiZlAjU.png', 1514454956, 1514454956, NULL, '', '1', 0, 0, 0, 0, 1, '', 0.00, '昆明', '云南', '', 'adc5842c-f4ec-4f11-8836-aea8d04cf74f', '', '', '');
INSERT INTO `user` VALUES (13, 'oPnMk0WjxUxYY0dvqDOGiKda3lVg', 'onJre1H02e7XS1i_PyqFvUgHVArs', '娜乌西卡', 'https://wx.qlogo.cn/mmopen/vi_32/9BmuCZbgVF519yxY6HP481JmFfrf9mJTk585lmYknK4cicAUmogciaVgZTHl11RP2ZErBM0FOXXHaSxv7mC4iazKg/0', 2, 0, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0WjxUxYY0dvqDOGiKda3lVg.png', 1514456016, 1514515237, NULL, '13529420616', '2', 0, 0, 0, 0, 1, '', 0.00, '昆明', '云南', '', 'ae441683-a85a-45ee-9f8b-e6801ce17fc4', '005', '徐晓虹', 'x');
INSERT INTO `user` VALUES (14, 'oPnMk0cae0ZgFLJ-hfJ0aNEWxh_Q', 'onJre1I0l_3Tnf3j3ZdnHUSWVfA4', '柴可夫斯基不是老司机', 'https://wx.qlogo.cn/mmopen/vi_32/6wRlxAoQ4OYDRV8UW4KyFjOcfCD7CyrZlmTulWhKMDfebbU0fT7iaFxicVaNIibSy3vt1HVDdQfBNaq4jApAkco9g/0', 2, 0, 'http://xxq.local.xuewl.com/attachment/qrcode/oPnMk0cae0ZgFLJ-hfJ0aNEWxh_Q.png', 1514472246, 1514520129, NULL, '13708404991', '1', 0, 0, 0, 0, 1, '', 0.00, '昆明', '云南', '', '3635f86c-267f-43f2-b300-d0cab6e51b81', '006', '柴总', 'c');
INSERT INTO `user` VALUES (15, 'oPnMk0dQa44Z-AxiQdKrb3NErewY', 'onJre1PBQHhovRg0ydT8q3-Teb00', '夜风', 'https://wx.qlogo.cn/mmopen/vi_32/iadic5ssR7t1oXvgKxhM2Pkf0ib6kA1AXtpCKg9wATHKnCyxyEe3PJ3FS3IRO6qHb83VfykfPvVkk5RQghrkXhevQ/0', 0, 0, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0dQa44Z-AxiQdKrb3NErewY.png', 1514507938, 1514507938, NULL, '', '1', 0, 0, 0, 0, 1, '', 0.00, '', '', '', 'd5e24d5e-63e8-45f3-af1a-24c1c65e56ab', '', '', '');
INSERT INTO `user` VALUES (16, 'oPnMk0VOQCAGAtheEddLaMBuwEQI', 'onJre1KG-Vx8GkZj9wmVSmXe8zss', 'Peter@Xiaozhe', 'https://wx.qlogo.cn/mmopen/vi_32/S6h3pRIScQtk4bHzicDwsub2QDlxj1cHMsQmppic0Z9x3842TcXniagW1SLfGWI85XnalIRP3W2iaHTTicdal5O2kHg/0', 2, 0, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0VOQCAGAtheEddLaMBuwEQI.png', 1514521066, 1514527706, NULL, '13099964653', '1', 0, 0, 0, 0, 1, '', 0.00, '南岸', '重庆', '', '2b2c7543-7301-4432-a567-a92eaa74ed10', '010', '朱博', 'z');
INSERT INTO `user` VALUES (17, 'oPnMk0YOLj0hSpcmfWiO6k8BoQqU', 'onJre1EyvDHuwtr9kEpw2wS4stR4', '夏超', 'https://wx.qlogo.cn/mmopen/vi_32/x7FM7kJxx1rQ3Iia4LSkMHNvL4xwY6YoibXJeb7LZ9kBogU3HmhEtLPBkucTVHAfZ08JIbqkvxmIAGHuAaLPabZw/0', 0, 0, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0YOLj0hSpcmfWiO6k8BoQqU.png', 1514526275, 1514526275, NULL, '', '1', 0, 0, 0, 0, 1, '', 0.00, '渝北', '重庆', '', '5c938b75-168a-4e98-b64c-43cd0aa50d1f', '', '', '');
INSERT INTO `user` VALUES (18, 'oPnMk0R_i55ZW8SCXNCj7YROLWoo', 'onJre1Bntz9QBzU84uQWAvRlYy9E', 'Peter', 'https://wx.qlogo.cn/mmopen/vi_32/ajNVdqHZLLDmAIrSicLbYlPxfwHTiaecfPPtntj6D4reeD4NdiaDGr3Me3qRtmUFLsxOqDvVMn1z1bur3PlgA6ZgQ/0', 0, 0, 'https://xxq.local.xuewl.com/attachment/qrcode/oPnMk0R_i55ZW8SCXNCj7YROLWoo.png', 1514528274, 1514528274, NULL, '', '1', 0, 0, 0, 0, 1, '', 0.00, '昆明', '云南', '', '09a10081-6c2c-48bb-aa69-70eba616041f', '', '', '');
COMMIT;

-- ----------------------------
-- Table structure for user_distributor
-- ----------------------------
DROP TABLE IF EXISTS `user_distributor`;
CREATE TABLE `user_distributor` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `name` varchar(100) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '公司名称',
  `area` varchar(200) CHARACTER SET utf8mb4 NOT NULL DEFAULT '0' COMMENT '所在地区',
  `address` varchar(200) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '公司地址',
  `license_pic` text CHARACTER SET utf8mb4 NOT NULL COMMENT '工商执照',
  `idcard_pic` text CHARACTER SET utf8mb4 NOT NULL COMMENT '法人证件',
  `works_pic` text COLLATE utf8mb4_bin NOT NULL COMMENT '与工作人员现场合影照片',
  `customer_id` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '所属客户经理',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态（-1；已驳回；0：待审批；1：已通过）',
  `manage_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '审核人',
  `manage_remark` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '审核备注',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户 - 分销商表';

-- ----------------------------
-- Records of user_distributor
-- ----------------------------
BEGIN;
INSERT INTO `user_distributor` VALUES (1, 2, '云南迪米盒子科技有限公司', '北京市,北京市,东城区', '北京路635号小城故事A座309室', '\"http:\\/\\/gy-yxc.oss-cn-beijing.aliyuncs.com\\/3a213bd63243ef4b3575a0e44ae06327a60dab38.jpg\"', '\"http:\\/\\/gy-yxc.oss-cn-beijing.aliyuncs.com\\/f5d7206c1969d2768bba85fd945f724b1ef13c49.jpg,http:\\/\\/gy-yxc.oss-cn-beijing.aliyuncs.com\\/6c40926fa02\"', '\"\"', 0, 1, 0, '', 1514442988, 1514443352, NULL);
INSERT INTO `user_distributor` VALUES (2, 3, '126', '北京市,北京市,东城区', 'ill哦哦了', '\"http:\\/\\/gy-yxc.oss-cn-beijing.aliyuncs.com\\/776849fced6b0955f6764cd2a0b12fb67330c680.jpg\"', '\"http:\\/\\/gy-yxc.oss-cn-beijing.aliyuncs.com\\/5dd7eb777f9a2aa3e7464c21d071a68cbbe777a5.jpg,http:\\/\\/gy-yxc.oss-cn-beijing.aliyuncs.com\\/5dd7eb777f9\"', '\"\"', 0, 1, 0, '', 1514443064, 1514443341, NULL);
INSERT INTO `user_distributor` VALUES (3, 1, 'UserDistributor', '北京市,北京市,东城区', '请我', '\"http:\\/\\/gy-yxc.oss-cn-beijing.aliyuncs.com\\/4f491f4dbf915f1d14fd0a97a2b93792a03a2f08.jpg\"', '\"wxfile:\\/\\/tmp_fdc64f00b0dc8273197c7cbcab7163ba.jpg,http:\\/\\/gy-yxc.oss-cn-beijing.aliyuncs.com\\/6ae964ed0091f7bd65909fde08eb02cf2c3e3cef.jpg\"', '\"\"', 0, 1, 0, '122324', 1514444181, 1514478390, NULL);
COMMIT;

-- ----------------------------
-- Table structure for user_point_log
-- ----------------------------
DROP TABLE IF EXISTS `user_point_log`;
CREATE TABLE `user_point_log` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增',
  `uid` int(11) NOT NULL DEFAULT '0',
  `type` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '业务类型',
  `point` int(11) NOT NULL DEFAULT '0' COMMENT '变动说明',
  `msg` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '变动说明',
  `order_no` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '关联订单',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0',
  `delete_time` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户 - 积分日志表';

-- ----------------------------
-- Records of user_point_log
-- ----------------------------
BEGIN;
INSERT INTO `user_point_log` VALUES (1, 3, 'goods', -533, '兑换兑换扣除积分测试实物商品2', 'G20180101223939689570', 0, 0, NULL);
INSERT INTO `user_point_log` VALUES (2, 3, 'goods', -533, '兑换扣除积分 - 测试实物商品2', 'G20180101224127561027', 1514817688, 1514817688, NULL);
COMMIT;

-- ----------------------------
-- Table structure for wechat_fans
-- ----------------------------
DROP TABLE IF EXISTS `wechat_fans`;
CREATE TABLE `wechat_fans` (
  `openid` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `unionid` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `subscribe_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否关注',
  `subscribe_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '关注时间',
  `unsubscribe_time` int(10) unsigned NOT NULL DEFAULT '0',
  `user_name` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '公众号原始ID',
  `latitude` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '地理位置纬度',
  `longitude` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '地理位置经度',
  `precision` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '地理位置精度',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0',
  `delete_time` int(10) DEFAULT NULL,
  PRIMARY KEY (`unionid`) USING BTREE,
  KEY `unionid` (`unionid`) USING BTREE,
  KEY `openid` (`openid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='粉丝表';

-- ----------------------------
-- Records of wechat_fans
-- ----------------------------
BEGIN;
INSERT INTO `wechat_fans` VALUES ('obVzzjuO7uJ7UjwVQqIaGiUdeEDk', 'onJre1A1Sa7fegDeEC1WYBNZpOWQ', 0, 0, 1514535542, 'gh_ffb20e7314c2', '', '', '', 1514535558, 1514535558, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzji0G3qFU_gBoNgvbZ-rQTq4', 'onJre1A29Isv4G1OupFh9pE1lLPM', 0, 0, 1514535420, 'gh_ffb20e7314c2', '', '', '', 1514535436, 1514535436, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjpBxhRBGXKWaTeEq9HbgE4I', 'onJre1A2tPtS_7Nl5RZPkn1HlnyA', 0, 0, 1514447514, 'gh_ffb20e7314c2', '', '', '', 1514447537, 1514447537, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjiTD1VomS8snsFoGEFLDF7g', 'onJre1A98z7RtEeupdDM03AaLdNw', 0, 0, 1514470126, 'gh_ffb20e7314c2', '', '', '', 1514470167, 1514470167, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjtU2m7HQQtdk-DSJ5P9asJo', 'onJre1AKEgQaIf3iIwW0JFiuRPr8', 0, 0, 1514441989, 'gh_ffb20e7314c2', '', '', '', 1514442009, 1514442009, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjh8hio12W69xuYRAE9Y73CQ', 'onJre1AKtjPpXiFaXJmkud_Ebpas', 0, 0, 1514536757, 'gh_ffb20e7314c2', '', '', '', 1514536773, 1514536773, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjppCvI5Jqi8U5YR8RiFNFU4', 'onJre1AqaSAPV9YZIwGNk001cLBs', 0, 0, 1514537792, 'gh_ffb20e7314c2', '', '', '', 1514537809, 1514537809, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjv5qQG3IR1WA1aZAv8l00hM', 'onJre1AvNxfHqkZ3XoDublpuDAkc', 0, 0, 1514440746, 'gh_ffb20e7314c2', '', '', '', 1514440765, 1514440765, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjhmDBvlHntNl1YlhKMmuJ8k', 'onJre1AylfH7UmPcrBgGGeuWyP8k', 0, 0, 1514465129, 'gh_ffb20e7314c2', '', '', '', 1514465165, 1514465165, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjlAqbkwQowQfIoRtZXmjOzw', 'onJre1AyunVdOZbfltNt9J3ROkIQ', 0, 0, 1514536744, 'gh_ffb20e7314c2', '', '', '', 1514536760, 1514536760, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjl5vnOQeekWgArT_ID2mbK4', 'onJre1Az5Sgsd2usOQ6ZT-9hXYgI', 0, 0, 1514536431, 'gh_ffb20e7314c2', '', '', '', 1514536447, 1514536447, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjjuyAAVXhXF6eUFGW78LZJw', 'onJre1B2HP1_QtX6IHoG6QFjDBwQ', 0, 0, 1514535601, 'gh_ffb20e7314c2', '', '', '', 1514535616, 1514535616, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjufo666PsXB6vtp9l4Ezx6I', 'onJre1B8Ny_HlPScvyD9kuRm9iNQ', 0, 0, 1514518628, 'gh_ffb20e7314c2', '', '', '', 1514516847, 1514516847, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjl-2GEFPEdanIAv_g7Qicgs', 'onJre1BAeqt1WYmDBE7hBDC2Iwsw', 0, 0, 1514535318, 'gh_ffb20e7314c2', '', '', '', 1514535334, 1514535334, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjqOdyzpp0M0vJrIVOfsVTtU', 'onJre1BC6S-ooi675wwC4S47feUU', 0, 0, 1514504364, 'gh_ffb20e7314c2', '', '', '', 1514502261, 1514502261, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjvJCvviXNuYbMM6gx0SIMMM', 'onJre1BIjTpbpVKRW8nNP4HuVwDg', 0, 0, 1514465033, 'gh_ffb20e7314c2', '', '', '', 1514465069, 1514465069, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjlcscPUu2_HPVptjH8tkfe8', 'onJre1BLtZ5TbOEECd8LSfZ6hQpA', 0, 0, 1514445769, 'gh_ffb20e7314c2', '', '', '', 1514445792, 1514445792, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjs0ZPjlAG5VoO4z8UaZ9-ak', 'onJre1BZgMgMtG4FzlwPU8BXG6ZU', 0, 0, 1514451311, 'gh_ffb20e7314c2', '', '', '', 1514451338, 1514451338, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjpOB3WNJNZk-COY6i4nmzrU', 'onJre1BbKt5KFXjP45aTFvOvenmE', 0, 0, 1514536477, 'gh_ffb20e7314c2', '', '', '', 1514536493, 1514536493, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjmSdBS5BoUQVLJL-vfLZoiM', 'onJre1Bi4ohJD_VNi1V-N8l6e3kk', 0, 0, 1514535483, 'gh_ffb20e7314c2', '', '', '', 1514535498, 1514535498, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjhUzYwnw-fXclGvcGxLNKcM', 'onJre1BkcuvdU8IGFegYw3kKcfK4', 0, 0, 1514536683, 'gh_ffb20e7314c2', '', '', '', 1514536699, 1514536699, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjipLnaXXz0VdWTCRShyRK5M', 'onJre1BlcJeLt-3TSEXbxXeUFQMc', 0, 0, 1514452044, 'gh_ffb20e7314c2', '', '', '', 1514452071, 1514452071, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjoXVxlxf39TzcPimeXiSA6o', 'onJre1Bntz9QBzU84uQWAvRlYy9E', 1, 1514528184, 0, 'gh_ffb20e7314c2', '', '', '', 1514528195, 1514528195, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjnjFODZzQ_g6faWHUgVaRVE', 'onJre1Bse8eTQvPOzq1IGML21Qpg', 0, 0, 1514538383, 'gh_ffb20e7314c2', '', '', '', 1514538401, 1514538401, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjksnuZIj1sMiy2tl5k2aN94', 'onJre1Buh9EIKuf5eqPX4TI7otYc', 0, 0, 1514507342, 'gh_ffb20e7314c2', '', '', '', 1514505246, 1514505246, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjptS9b7PDogriFeBfosR8yg', 'onJre1BzvmsGshSAd6Rf7I7uVe6E', 0, 0, 1514536460, 'gh_ffb20e7314c2', '', '', '', 1514536477, 1514536477, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjs2B3p8CUNom-TywRycua28', 'onJre1C4PuUU6MnfqRakwczCNzxI', 0, 0, 1514450463, 'gh_ffb20e7314c2', '', '', '', 1514450489, 1514450489, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjrGjCDxyYVzOofBpNh1AWTI', 'onJre1C7_wYNeykOupjuoKpik82s', 0, 0, 1514535554, 'gh_ffb20e7314c2', '', '', '', 1514535570, 1514535570, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjiAgh14fFRplF29RU9VPyY4', 'onJre1CDCHUVilJbrPfR60oUhh2w', 0, 0, 1514468343, 'gh_ffb20e7314c2', '', '', '', 1514468383, 1514468383, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjscoyaYmWqEpBDaUSCqS0TQ', 'onJre1CR7Psf5DFmfrhY0RrOSOdM', 0, 0, 1514537496, 'gh_ffb20e7314c2', '', '', '', 1514537512, 1514537512, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjllJg_fE11aCY3NwNmgBwGM', 'onJre1CRGhvBH7IVlT9JyYJiEfME', 0, 1514441025, 1514441045, 'gh_ffb20e7314c2', '', '', '', 1514441045, 1514441064, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjv6r4ZUjuIMdtCGAmNpNKYU', 'onJre1CTq5hmjI9tXoGxqSeHJixQ', 0, 0, 1514537683, 'gh_ffb20e7314c2', '', '', '', 1514537700, 1514537700, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjhf8bo0RKGaQ6MRB8c76KlM', 'onJre1CZfC2ys5fNM3dE-HiKRFdo', 0, 0, 1514486518, 'gh_ffb20e7314c2', '', '', '', 1514484396, 1514484396, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjtHr7iSGuSIfd2-K9MykTik', 'onJre1CaVhIAh5G_-G6sCD3ZasLE', 0, 0, 1514536664, 'gh_ffb20e7314c2', '', '', '', 1514536680, 1514536680, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjq8Smh69n8lYQ25FshIXVmA', 'onJre1ClVvfoXIcgg9_IyyY32ZJ0', 0, 0, 1514535286, 'gh_ffb20e7314c2', '', '', '', 1514535302, 1514535302, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjl1ny_RS6N0m6KXkYxh30BA', 'onJre1CsimT2IiRkGtuPgkMzWw4k', 0, 0, 1514546755, 'gh_ffb20e7314c2', '', '', '', 1514546780, 1514546780, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjqTWqUsNFH47Z4TecAYUW4Y', 'onJre1CwXnulpyOouiPrqMiF2sXE', 0, 0, 1514535676, 'gh_ffb20e7314c2', '', '', '', 1514535693, 1514535693, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjs7lb3mLDazmPT7wwFv6F1k', 'onJre1D1hpGBUHW5OtUseXWum-Ik', 0, 0, 1514463650, 'gh_ffb20e7314c2', '', '', '', 1514463685, 1514463685, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjlppy4R4Vs4RI4WD8ijQ1uI', 'onJre1D93Oi9xLZx7azDEEklTwxQ', 0, 0, 1514535572, 'gh_ffb20e7314c2', '', '', '', 1514535588, 1514535588, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjqivftzikK9vZKxiT8O6DnY', 'onJre1DAgpvyOF9X1O7TaZqHKg5Q', 0, 0, 1514535653, 'gh_ffb20e7314c2', '', '', '', 1514535669, 1514535669, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzji-9O2U-aIAIO8JuIrJ2Rvk', 'onJre1DC35GPBHrIIhvaJZRJlUJc', 0, 0, 1514487626, 'gh_ffb20e7314c2', '', '', '', 1514485504, 1514485504, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjpO0qgC6V1oirijWJ63hJW8', 'onJre1DGKJJrruDg-eofhUHxpExo', 0, 0, 1514536496, 'gh_ffb20e7314c2', '', '', '', 1514536513, 1514536513, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjhzZOs-gmWSc5zu8FuHc_BQ', 'onJre1DPOlxXAmQXxc3EBtEOFWyE', 0, 0, 1514536211, 'gh_ffb20e7314c2', '', '', '', 1514536232, 1514536232, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjo-WxPQUwn4ubcB3Cjof2s4', 'onJre1DQtTq1OCdcx1_3l65qy0sY', 0, 0, 1514447474, 'gh_ffb20e7314c2', '', '', '', 1514447498, 1514447498, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjoNPUuXE6dr8PkRQEtu94ZY', 'onJre1DX87196QplPmbk8mbp87eY', 1, 1514476738, 0, 'gh_ffb20e7314c2', '', '', '', 1514476782, 1514476782, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjo5oizNDs_Zq5jwx6On_wZ0', 'onJre1DnKdZZllgyMFrYx9f22Dic', 0, 0, 1514537837, 'gh_ffb20e7314c2', '', '', '', 1514537854, 1514537854, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjqReW_lsoRvknMeddojpQgI', 'onJre1DoE__5kBzdOES07xOApWzU', 0, 0, 1514541141, 'gh_ffb20e7314c2', '', '', '', 1514541161, 1514541161, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjo7OEWWLz7JXBE0ttpj-f3I', 'onJre1DsCwKmoIq2k0ATJcmd1-Ng', 0, 0, 1514536430, 'gh_ffb20e7314c2', '', '', '', 1514536446, 1514536446, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjvJIaV3-g-OLHaKbbO4pd5E', 'onJre1DuxR2GkxqcFKUz_b-KDxXI', 0, 0, 1514539020, 'gh_ffb20e7314c2', '', '', '', 1514539038, 1514539038, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjvAooFh9F8gjtUuZcpYq_7o', 'onJre1E0Ri5VlzFmzz-MiZkmVblU', 0, 0, 1514547031, 'gh_ffb20e7314c2', '', '', '', 1514547055, 1514547055, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjhO2BbbL5O_jl92dg-ILvso', 'onJre1E2tkTY7Q-_P8PhVGPwURTs', 0, 0, 1514535318, 'gh_ffb20e7314c2', '', '', '', 1514535334, 1514535334, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjmzko9Xt7vNrTztqy7Ts4mM', 'onJre1E6VoEfMmcbt5ZLy2qVN9GU', 0, 0, 1514466782, 'gh_ffb20e7314c2', '', '', '', 1514466819, 1514466819, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjmTq4-gFn_awkz0_4hv6IhA', 'onJre1E9TahfnAFwQ7hKfQyNzaRg', 0, 0, 1514538509, 'gh_ffb20e7314c2', '', '', '', 1514538527, 1514538527, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjtd976RxZVi_k11SbI5cwbc', 'onJre1E9t62_4h0zC-70Ud8NQYHM', 0, 0, 1514542824, 'gh_ffb20e7314c2', '', '', '', 1514542845, 1514542845, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjlsthUeWPQQ2Jg_tFz74NlE', 'onJre1EDJs1McBeNPsE-fdAQoZIE', 0, 0, 1514494292, 'gh_ffb20e7314c2', '', '', '', 1514492181, 1514492181, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjiLA4Dsq6wvCzJuXXfMKNr0', 'onJre1ENNvF68_cTJiCmU27bZMLc', 0, 0, 1514535375, 'gh_ffb20e7314c2', '', '', '', 1514535390, 1514535390, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjlouVtwdDNnf6i1_8yFUXec', 'onJre1EZjv344Y-mOjvkr-sKLXUU', 0, 0, 1514535311, 'gh_ffb20e7314c2', '', '', '', 1514535332, 1514535332, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjogv_dPGn-bE6OWMWL_19uI', 'onJre1E_3-T_jH9HO5jOWJRjZnqA', 0, 0, 1514535753, 'gh_ffb20e7314c2', '', '', '', 1514535770, 1514535770, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzji2gliA0coWgaD3H6BB1rYY', 'onJre1Eb2GWhEk7_TQ7vuZWlmIlA', 0, 0, 1514441679, 'gh_ffb20e7314c2', '', '', '', 1514441699, 1514441699, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjrUxpREMoHj1G_aGRPU4AX4', 'onJre1EcSdggAMxbJqwEB8WaO8wQ', 0, 0, 1514536600, 'gh_ffb20e7314c2', '', '', '', 1514536617, 1514536617, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjhH2Uu62K8kwagGdXkyMre8', 'onJre1EfTtDRu_dbKk68Uy__19_Q', 0, 0, 1514535692, 'gh_ffb20e7314c2', '', '', '', 1514535708, 1514535708, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjov_N_ZpesM6oIhqkwgs6gQ', 'onJre1EjBXF4lpFcLTWuiOuEBcr0', 0, 0, 1514449180, 'gh_ffb20e7314c2', '', '', '', 1514449206, 1514449206, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjkrfpmxB7Oxi0thh6CU3vrQ', 'onJre1EpsIiux1JaLfObhoDtxJrU', 0, 0, 1514540898, 'gh_ffb20e7314c2', '', '', '', 1514540917, 1514540917, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjhOw80jwMeZ7vGbdsGHvAOE', 'onJre1ErLClHMW8fOBUIHfLO2DJE', 0, 0, 1514541661, 'gh_ffb20e7314c2', '', '', '', 1514541681, 1514541681, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjlMVOb9REkHjrrfJ6qLhX68', 'onJre1Eu5hn_RK8aCM8WO94aneTs', 0, 0, 1514520985, 'gh_ffb20e7314c2', '', '', '', 1514520991, 1514520991, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjhxRqeo-Wn_9Mmgo_Sgvkps', 'onJre1EuKwhjl5sGGXTnk0QH6KhQ', 0, 0, 1514441452, 'gh_ffb20e7314c2', '', '', '', 1514441472, 1514441472, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzju2n35iU9bllGryJIJtQtds', 'onJre1EyTpNNb7-bGp9FlDHd4XQ8', 0, 0, 1514535572, 'gh_ffb20e7314c2', '', '', '', 1514535588, 1514535588, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjux63UvbmmcY5jyyVLePUuM', 'onJre1EyvDHuwtr9kEpw2wS4stR4', 1, 1514526227, 0, 'gh_ffb20e7314c2', '', '', '', 1514526236, 1514526236, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjsKCnYiI5MZCqX-zjxwdr08', 'onJre1EzU-56um55OPlR41OeKCeM', 0, 0, 1514537726, 'gh_ffb20e7314c2', '', '', '', 1514537743, 1514537743, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjk3iUPUbPl5T0Ncc-E8RKXs', 'onJre1F1b2bqTjoubHJqY_wL3EuQ', 0, 0, 1514535325, 'gh_ffb20e7314c2', '', '', '', 1514535341, 1514535341, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjjNhaBJrK3qo3L8sNyDMVn0', 'onJre1F3MPEUB_2FXczQT58ePzQI', 0, 0, 1514540811, 'gh_ffb20e7314c2', '', '', '', 1514540830, 1514540830, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjt4fbMcj5qh-pWsEfajdCqM', 'onJre1F4a9zdaKImK-eMVRNZpqGc', 0, 0, 1514539189, 'gh_ffb20e7314c2', '', '', '', 1514539207, 1514539207, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjl11Nx5HPXCvtVGPAahi2dM', 'onJre1FGpAAE2m5ugggiteQa9OZs', 0, 0, 1514449653, 'gh_ffb20e7314c2', '', '', '', 1514449679, 1514449679, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjq_h_2HfrR3y84-gFiF_2gA', 'onJre1FIGdd9nzfA4TclhDKsjWHE', 0, 0, 1514442017, 'gh_ffb20e7314c2', '', '', '', 1514442037, 1514442037, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjtj0BtNAfNVClnsiJjWgirQ', 'onJre1FIx-IJxJ0Km3404_HwbSSM', 0, 0, 1514468085, 'gh_ffb20e7314c2', '', '', '', 1514468124, 1514468124, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjuPl-6drGGTTLWDSxO-f0gs', 'onJre1FOgLJVuw01rHQDJQwyO1IM', 0, 0, 1514537701, 'gh_ffb20e7314c2', '', '', '', 1514537718, 1514537718, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjgXxQHFFjC-x1O_CRShfMGk', 'onJre1FTBTRxvaKjYR3olW26OrZc', 0, 0, 1514536419, 'gh_ffb20e7314c2', '', '', '', 1514536435, 1514536435, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjuEi28Azln6_xRp-uVYMQPw', 'onJre1FZhInN572gxdboW9fhyi_k', 1, 1514477665, 0, 'gh_ffb20e7314c2', '', '', '', 1514477711, 1514477711, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjtSlgKZdLeQg3EGNgJcB9lA', 'onJre1FZsAz2Djk3jhDex830Il1o', 0, 0, 1514536279, 'gh_ffb20e7314c2', '', '', '', 1514536296, 1514536296, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjpJiwNnUUZdK52R2hdgMa_0', 'onJre1Fc2nmwhqpBKHSHtcGcUdnM', 0, 0, 1514537547, 'gh_ffb20e7314c2', '', '', '', 1514537563, 1514537563, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjrwJlftxFLlLPZbfyd9cv58', 'onJre1FfS0ACIuck94Bqc3DM8I_g', 0, 0, 1514468836, 'gh_ffb20e7314c2', '', '', '', 1514468876, 1514468876, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjkJdjMfpKtC6dChPr1z2mrQ', 'onJre1FfhG3oJEBaUyXpltP54JAY', 1, 1514449974, 0, 'gh_ffb20e7314c2', '', '', '', 1514450000, 1514450000, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjmDMI5IpyA-4-feZPTgTAn4', 'onJre1FnNaG3CV8geGAyPaulxeyY', 0, 0, 1514473392, 'gh_ffb20e7314c2', '', '', '', 1514473434, 1514473434, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjheVvE2lW2bq_rZr9QXRr9M', 'onJre1FrElX61JFhmp4kKhm66VZg', 0, 0, 1514535574, 'gh_ffb20e7314c2', '', '', '', 1514535590, 1514535590, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjlt-99XffklKW-vGgVzXesg', 'onJre1G0FNQ0npBGeTSe8-1lJ1eY', 0, 0, 1514520561, 'gh_ffb20e7314c2', '', '', '', 1514520568, 1514520568, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjhdLH5miq1qXvG7vD--TAac', 'onJre1G377MCZb3DrKN-BWBdgX5A', 0, 0, 1514535575, 'gh_ffb20e7314c2', '', '', '', 1514535591, 1514535591, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjsX9B6XVvyrbSE_nX9BQ9rs', 'onJre1G5hE5V2NnZn_9bEwP3o7zw', 0, 0, 1514545452, 'gh_ffb20e7314c2', '', '', '', 1514545474, 1514545474, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjohxkEUXAfyDbihQmIIwBxY', 'onJre1G9oe-TzphtiizFqIvfL5MU', 0, 0, 1514536962, 'gh_ffb20e7314c2', '', '', '', 1514536979, 1514536979, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjr_dzLZ2P5_s814txRpGgaE', 'onJre1GBLytehQzsNUtqxbNtB74g', 0, 0, 1514462374, 'gh_ffb20e7314c2', '', '', '', 1514462409, 1514462409, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjjm2lTZiFmp5GGikYwTZOKw', 'onJre1GD1RU1FHC2nFTTgVaWdeMY', 0, 0, 1514513709, 'gh_ffb20e7314c2', '', '', '', 1514511923, 1514511923, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjuFfBfMSmws6klrrFymsldM', 'onJre1GDmtnYkzE9VQyl1NXqoEgQ', 1, 1514440902, 1514440890, 'gh_ffb20e7314c2', '', '', '', 1514440910, 1514440921, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjgyzUIqKmn45KJZMW2Em9Cw', 'onJre1GIfZAhLWQig_Pnwc3Hsio0', 0, 0, 1514535546, 'gh_ffb20e7314c2', '', '', '', 1514535561, 1514535561, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjuV4UlYrNzEL3TQnkVX5-6w', 'onJre1GKvnOicrtKj4qKyB2bmLu0', 0, 0, 1514441482, 'gh_ffb20e7314c2', '', '', '', 1514441502, 1514441502, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzji616nn31Gkat5SISHaYch4', 'onJre1GM2QMfDtxtcr0u4iAMhb2A', 0, 0, 1514538442, 'gh_ffb20e7314c2', '', '', '', 1514538459, 1514538459, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjqYuWtTrHZ_HvHeWpqxRm1E', 'onJre1GO45EbToCMfQX-NBFMBGQQ', 0, 0, 1514537279, 'gh_ffb20e7314c2', '', '', '', 1514537296, 1514537296, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjn382vsq6cGo1s1KxqGdWyc', 'onJre1GP-Q4ja5ORaIlC7fQKlVWA', 0, 0, 1514539689, 'gh_ffb20e7314c2', '', '', '', 1514539707, 1514539707, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjleJj2_Ay09Tp1rJqAK4YOk', 'onJre1GPh44rEZ3bSX8MLztOPjHs', 0, 0, 1514467087, 'gh_ffb20e7314c2', '', '', '', 1514467125, 1514467125, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjkRjm7Uy-q1QpdGUyr9c8NE', 'onJre1G_xCoH3tNBxGqU8Ony-4TY', 0, 0, 1514477128, 'gh_ffb20e7314c2', '', '', '', 1514477173, 1514477173, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjve6VZ6evDMxkZVe0DhmGFU', 'onJre1GcktEhgZm33Kf4ze2f9SGo', 0, 0, 1514503768, 'gh_ffb20e7314c2', '', '', '', 1514501666, 1514501666, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjkOwpOoVN5ygEDkVClfzAzs', 'onJre1GdZbXuevhuLf4AtJlSNpkQ', 0, 0, 1514456761, 'gh_ffb20e7314c2', '', '', '', 1514456792, 1514456792, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjrLboqQmUgqYUZ7Jb0daY-I', 'onJre1GoyVTlBujO-F96z0v6c_1Q', 0, 0, 1514538176, 'gh_ffb20e7314c2', '', '', '', 1514538193, 1514538193, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjv0tcdFglDILjOLbbkrOcR8', 'onJre1Gpyp3QNkSGXJV_Pr071Mz0', 0, 0, 1514535288, 'gh_ffb20e7314c2', '', '', '', 1514535304, 1514535304, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjgolyNoZZ3B9IWwPqgFcyaM', 'onJre1GuUDL58yY2jwhuHB2gk4xM', 1, 1514532943, 0, 'gh_ffb20e7314c2', '', '', '', 1514532957, 1514532957, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjimggPFsMKRCDRuwF2_BcIk', 'onJre1GvUd4DjZ7GX0RQIWdLKohU', 0, 0, 1514535957, 'gh_ffb20e7314c2', '', '', '', 1514535974, 1514535974, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjqMPnbM4ljuTqqbzllLWLJQ', 'onJre1Gvh8alMNPOmq2YHHwPpQck', 0, 0, 1514470392, 'gh_ffb20e7314c2', '', '', '', 1514470432, 1514470432, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjiSRI1s4P56LYcT_1PHbvTc', 'onJre1GwVLixdaTeN7VlrxCMBQ3A', 0, 0, 1514537301, 'gh_ffb20e7314c2', '', '', '', 1514537318, 1514537318, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjk2W01GtOTrTme1BBiA9phg', 'onJre1Gzxefy3V1b1P3ufTr2eSFM', 0, 0, 1514536766, 'gh_ffb20e7314c2', '', '', '', 1514536782, 1514536782, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjvWfc0oZrY4RX1GeEojW20c', 'onJre1H4qEffeXaHaykQe8WCWUpA', 1, 1514466937, 0, 'gh_ffb20e7314c2', '', '', '', 1514466975, 1514466975, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjrT5wXGDrbnYEERykt6C5yY', 'onJre1H6FvHSCu7UC-JApIZwq4NY', 0, 0, 1514531808, 'gh_ffb20e7314c2', '', '', '', 1514531822, 1514531822, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjgrY8eVjnb5vRaL-EovalUk', 'onJre1HH0U2XOTJCdJu7x29gdNW4', 0, 0, 1514537772, 'gh_ffb20e7314c2', '', '', '', 1514537789, 1514537789, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjo_k800RtizLZj1DQH_bhCI', 'onJre1HHnLbuBLZ_W9LOZXmsSQ7Y', 0, 0, 1514543494, 'gh_ffb20e7314c2', '', '', '', 1514543516, 1514543516, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjngpOq9NtUhsKP9pK8OMDhY', 'onJre1HJHNHorMXeijl6oZBztHQ0', 0, 0, 1514535415, 'gh_ffb20e7314c2', '', '', '', 1514535431, 1514535431, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjmoE801aj80AJaWYsmffYJA', 'onJre1HOFZwlT56ta8yqcGQzMZEc', 0, 0, 1514537086, 'gh_ffb20e7314c2', '', '', '', 1514537103, 1514537103, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjj9gV1Mvwfxp1zoTfG0MZsM', 'onJre1HQIATtcujuXXdY7hwi2RS0', 0, 0, 1514535346, 'gh_ffb20e7314c2', '', '', '', 1514535363, 1514535363, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjpo-Dwn-QnsZwOvfylY1KkY', 'onJre1HVslf9jQTUWOrU9WuMOYDQ', 0, 0, 1514536147, 'gh_ffb20e7314c2', '', '', '', 1514536167, 1514536167, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjhEv2auIlIhpi5OINjlX3Yk', 'onJre1HaRa4lSwxjlm7q2InRvYqU', 0, 0, 1514472236, 'gh_ffb20e7314c2', '', '', '', 1514472278, 1514472278, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjtz783DeEkYKXCxpu3wF6no', 'onJre1HdpQLJCyTy45MNyeJ7-Tv8', 0, 0, 1514535249, 'gh_ffb20e7314c2', '', '', '', 1514535268, 1514535268, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjmLh6UHTXTBkALn_LqvdiLI', 'onJre1HgwbiNZcuM_FjK-sFIYmG8', 0, 0, 1514471662, 'gh_ffb20e7314c2', '', '', '', 1514471703, 1514471703, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjmGRUDzUDgUgHp0N5nvspLo', 'onJre1HhOXA1bPadl7gbRZdYAuto', 1, 1514462930, 0, 'gh_ffb20e7314c2', '', '', '', 1514462965, 1514462965, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjscrvRIz7nCyDJAMK2HMuyQ', 'onJre1HlVEO1WBngys0OmN98GynM', 0, 0, 1514450825, 'gh_ffb20e7314c2', '', '', '', 1514450851, 1514450851, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjq_3zkN7UcUhrKPijEIOu0s', 'onJre1HlaqcNgHkHH5yvpUTKFFB8', 0, 0, 1514535297, 'gh_ffb20e7314c2', '', '', '', 1514535313, 1514535313, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjjoJU4wJN-BBqRipMXT8EUw', 'onJre1HpbTq6PX8nv5o147jreEQo', 0, 0, 1514443025, 'gh_ffb20e7314c2', '', '', '', 1514443046, 1514443046, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjgbaqzT61ZtPFf8QJog7HWE', 'onJre1I1qkvW5nnCgJG5c3qeKqh8', 0, 0, 1514537885, 'gh_ffb20e7314c2', '', '', '', 1514537903, 1514537903, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjmyxn5qtej_da-vkIipVkfc', 'onJre1I5ypjx2JT1XcS2vaLu49S8', 0, 0, 1514535335, 'gh_ffb20e7314c2', '', '', '', 1514535351, 1514535351, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjqrBawk1Xtx5lycamkUnqdg', 'onJre1IAFVHe4U181DK9GFdJAWyw', 0, 0, 1514505422, 'gh_ffb20e7314c2', '', '', '', 1514503321, 1514503321, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjtNsO1359EVwWSVE_Lc_cKw', 'onJre1IHfaRN9xZnI8YCxnkVhQoM', 0, 0, 1514515755, 'gh_ffb20e7314c2', '', '', '', 1514513971, 1514513971, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjkwRB9vLLzwMliPvXo3NAUQ', 'onJre1IOLtjGrbhRuV-XX6Be-WmE', 0, 0, 1514448147, 'gh_ffb20e7314c2', '', '', '', 1514448171, 1514448171, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjjibR02JhEuMawSBSRKPHY0', 'onJre1Idc_Z6ZT4iBWgWT7V0newg', 0, 0, 1514535367, 'gh_ffb20e7314c2', '', '', '', 1514535384, 1514535384, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjlIEdeXq-LOhNJNjd0k8JzY', 'onJre1IlXvw6CRiBwxouZmEk3NU4', 0, 0, 1514537818, 'gh_ffb20e7314c2', '', '', '', 1514537835, 1514537835, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjpszwH55nFKWwf_RhI8KvPk', 'onJre1Ilgex4JgubmelcmS7bIeo0', 0, 0, 1514535298, 'gh_ffb20e7314c2', '', '', '', 1514535313, 1514535313, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjmOjILmMA2eCAdoFhlycw4A', 'onJre1Imnc0r3ttRHVwrQufIDL9E', 0, 0, 1514537659, 'gh_ffb20e7314c2', '', '', '', 1514537676, 1514537676, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjpzZVCUY8hZyVR7mHIDa2d8', 'onJre1InALu0TbZGKHoHw4UMTfBY', 0, 0, 1514535363, 'gh_ffb20e7314c2', '', '', '', 1514535379, 1514535379, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjmCUu_zKU5KudXTbB8zOQws', 'onJre1IpUjj_uxDMMZfmt2288n_k', 0, 0, 1514535267, 'gh_ffb20e7314c2', '', '', '', 1514535284, 1514535284, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjgc2KaXGOl7wZKszwSxCguI', 'onJre1J5X76kd_uWqw35bvimJcMs', 0, 0, 1514536791, 'gh_ffb20e7314c2', '', '', '', 1514536807, 1514536807, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjklO_vxzQAubtbTBLed0fcQ', 'onJre1JHmVZKGTL1v5hqCgAvM9hY', 0, 0, 1514464985, 'gh_ffb20e7314c2', '', '', '', 1514465021, 1514465021, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjklOkvUKEQb_0UtOyvk0zQk', 'onJre1JJi0HdiGpP10a4tMnXhPCA', 0, 0, 1514539069, 'gh_ffb20e7314c2', '', '', '', 1514539087, 1514539087, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjt6xL5_1BPlB1FGSq_ZQGbs', 'onJre1JLpWdGEV2os7fhkTkzROp4', 0, 0, 1514536289, 'gh_ffb20e7314c2', '', '', '', 1514536305, 1514536305, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjgqM11KRBV1cCDc0maFEZYA', 'onJre1JLz7OBWUBkPIxeWAzvfmTk', 0, 0, 1514535807, 'gh_ffb20e7314c2', '', '', '', 1514535824, 1514535824, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjig62OeRdragi6XwmRBjzzc', 'onJre1JNcoC7vbEjBH1-CSRwM0GA', 0, 0, 1514454497, 'gh_ffb20e7314c2', '', '', '', 1514454526, 1514454526, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjpj35rn2HmU3eRAa6hfSM1k', 'onJre1JO6QCNgqGBX7nyGt7V-Sj8', 0, 0, 1514523512, 'gh_ffb20e7314c2', '', '', '', 1514523520, 1514523520, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjj08fODG4vr84hV6q_LGUu0', 'onJre1JO80Z_x-OAln4Rz82sGw-A', 0, 0, 1514450302, 'gh_ffb20e7314c2', '', '', '', 1514450328, 1514450328, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjrboJ9Fh9umywcVqXGILru8', 'onJre1JTqrhY9uGBm0lML3WyydTM', 0, 0, 1514462180, 'gh_ffb20e7314c2', '', '', '', 1514462223, 1514462224, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjrptE6oo8TCL6K16E3meUyE', 'onJre1J_Z8breHcKFvjCwfUox2RQ', 0, 0, 1514443774, 'gh_ffb20e7314c2', '', '', '', 1514443796, 1514443796, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjrVK8h7JeuF379vxgUW9__E', 'onJre1Jb9Mtet7N57tX2-LnUtYy8', 0, 0, 1514506553, 'gh_ffb20e7314c2', '', '', '', 1514504451, 1514504451, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjvALunVAjb_UgqBwu7Kw_tw', 'onJre1Jg0OlCkWWr33HCgYwFNgOU', 0, 0, 1514540735, 'gh_ffb20e7314c2', '', '', '', 1514540754, 1514540754, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjuMCzzmh3oUaHotdf4_mJ0I', 'onJre1JgSLr6iQkRLjmAfGYYb610', 0, 0, 1514546931, 'gh_ffb20e7314c2', '', '', '', 1514546956, 1514546956, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjoyx1m9Z2iaZ3xZWz5NJuYs', 'onJre1Jh8epRWLwe6C0C-rQE9T00', 0, 0, 1514453711, 'gh_ffb20e7314c2', '', '', '', 1514453740, 1514453740, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjqxHIKtdyjCwqvtwlwmigbA', 'onJre1JhcSii7LWd7LkHAS6lXB48', 0, 0, 1514535875, 'gh_ffb20e7314c2', '', '', '', 1514535891, 1514535891, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjq2pVUlRvx-Gkm6U_ZMcSho', 'onJre1JjxPfEOhTsocaeyGa2HVvE', 0, 0, 1514450536, 'gh_ffb20e7314c2', '', '', '', 1514450562, 1514450562, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjoISYml4choKmxlb2Z2mlFU', 'onJre1JqO7LLgIKjGIeSe47S9WIs', 0, 0, 1514535280, 'gh_ffb20e7314c2', '', '', '', 1514535297, 1514535297, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjqi7VMdNVrf6q0UlX4jOVWo', 'onJre1JsjgJBOxAZ7nGfvKXxHt8s', 0, 0, 1514536413, 'gh_ffb20e7314c2', '', '', '', 1514536429, 1514536429, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjpBGt9JX4a44wxq0-DA9wEo', 'onJre1JuIsSrShBxr_A4h8NanWEw', 0, 0, 1514543598, 'gh_ffb20e7314c2', '', '', '', 1514543619, 1514543619, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjh9ENtKGChirFYEwEpCHU1g', 'onJre1JvHfHn7tmTmFZGkHOaRi4U', 0, 0, 1514537360, 'gh_ffb20e7314c2', '', '', '', 1514537377, 1514537377, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjpjX0c_MUptWy2dgx3SZ-AA', 'onJre1K53YiOF17m4rsVA2tVf258', 0, 0, 1514536502, 'gh_ffb20e7314c2', '', '', '', 1514536518, 1514536518, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjvGEtRX8SOygTWenJOnWnr0', 'onJre1K6eUYG0ydYhBH92mG6TrwE', 0, 0, 1514536865, 'gh_ffb20e7314c2', '', '', '', 1514536881, 1514536881, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjnF5b7iXLrOsqrvi9oQvq2s', 'onJre1KJ8tG5HU52v5emrEKTbL5A', 0, 0, 1514535283, 'gh_ffb20e7314c2', '', '', '', 1514535300, 1514535300, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjpF5UpRu9TMW3hbNsHGXWTM', 'onJre1KLms623fkDWxXIljinTndE', 0, 0, 1514535780, 'gh_ffb20e7314c2', '', '', '', 1514535797, 1514535797, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjjbF7ZiOd-xjemypDsRr_5Q', 'onJre1KPd9_i74ThxFaVNY1MeQow', 0, 0, 1514547351, 'gh_ffb20e7314c2', '', '', '', 1514547381, 1514547382, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjjWAwRhWEJaUROkuJbRDWzs', 'onJre1KXqwiHOOY-KOkkjgPoUkjw', 1, 1514444364, 0, 'gh_ffb20e7314c2', '', '', '', 1514444386, 1514444386, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjra42mGHvDDmdwogtPhXvCI', 'onJre1KYnfM5x_2QZcIHK8Z4vXFM', 0, 0, 1514537284, 'gh_ffb20e7314c2', '', '', '', 1514537301, 1514537301, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjtAN1kv9_SPZ69nIyUEyvEI', 'onJre1Ki3pHqPk_6TJTz9GZNuXws', 0, 0, 1514538493, 'gh_ffb20e7314c2', '', '', '', 1514538511, 1514538511, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjkXi88tzpawFzEgABG0G8aA', 'onJre1KiBHgqOrVlMdCF417wpVx8', 0, 0, 1514445110, 'gh_ffb20e7314c2', '', '', '', 1514445133, 1514445133, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjgn7wBvN2EdFQZQmYrjcxHs', 'onJre1KiOMfkHkBZ25sYqpA_NKiA', 0, 0, 1514535270, 'gh_ffb20e7314c2', '', '', '', 1514535286, 1514535286, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjicdXVf9wbPHJ4_Abl5_qbc', 'onJre1Ks7PoSMD76skcQtBEXbj20', 0, 0, 1514517032, 'gh_ffb20e7314c2', '', '', '', 1514515249, 1514515249, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjsIpTCquUcpe6G6qdUAw1qo', 'onJre1KtNpiuGYL9gCMTc1gHQs_E', 0, 0, 1514533945, 'gh_ffb20e7314c2', '', '', '', 1514533960, 1514533960, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjmcGUVpnMEfn97kwDKHcndE', 'onJre1KwoB04qx4gIlYzQHomlGwE', 0, 0, 1514476915, 'gh_ffb20e7314c2', '', '', '', 1514476961, 1514476961, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjonlUC6UNuwI3gpO5HUOaWk', 'onJre1Kx_wKfqcr5AoC7Lfgp3UFI', 0, 0, 1514535317, 'gh_ffb20e7314c2', '', '', '', 1514535333, 1514535333, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjhdg5U15jgBGkDHuxxwr_r8', 'onJre1Kz8ZFDg-_CtaGAYi39s9Yo', 0, 0, 1514535455, 'gh_ffb20e7314c2', '', '', '', 1514535473, 1514535473, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjl3iBLixxL9KCXft1FyRBRg', 'onJre1L-W6PfXU2g05dPKGcj4ZkE', 0, 0, 1514465360, 'gh_ffb20e7314c2', '', '', '', 1514465397, 1514465397, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjsuv1vr8Amb5-tUkhzr66jU', 'onJre1L2RincGjRGmHSZJu0rN9hc', 0, 0, 1514442908, 'gh_ffb20e7314c2', '', '', '', 1514442930, 1514442930, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjvZQDmtlF6yLVzXrwqCI0xw', 'onJre1L3mO9tfzdILDFmwE-P6f9c', 0, 0, 1514458770, 'gh_ffb20e7314c2', '', '', '', 1514458802, 1514458802, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjiJTyWqpf5aJSe-277tnCxY', 'onJre1LCpOwWnMDylz90ulLNz8AA', 0, 0, 1514452126, 'gh_ffb20e7314c2', '', '', '', 1514452153, 1514452153, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjseMe0FjIh0iXOzmd0A97MI', 'onJre1LFLukSAXMZHjxWjBMUUwu4', 0, 0, 1514547694, 'gh_ffb20e7314c2', '', '', '', 1514547718, 1514547718, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjje32qLNimAlsczHdWgeePM', 'onJre1LFiU8r7mOstvSzWdozTXB4', 0, 0, 1514444879, 'gh_ffb20e7314c2', '', '', '', 1514444901, 1514444901, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjmgtxfMMaQmoWAcxp1F90hU', 'onJre1LHebxIFU_ELLuQmgFxspF0', 0, 0, 1514449151, 'gh_ffb20e7314c2', '', '', '', 1514449177, 1514449177, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjtB4lif0HzBmyzn5R1bJw5g', 'onJre1LJ5OTNlRZCec09keEHC0Wg', 0, 0, 1514544555, 'gh_ffb20e7314c2', '', '', '', 1514544577, 1514544577, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjmJTRYporIWwWRENzL9a9xM', 'onJre1LK5wqqHo10XUaORz4w1Ttw', 0, 0, 1514535375, 'gh_ffb20e7314c2', '', '', '', 1514535391, 1514535391, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjtUEDL5lB2OCRnj2f_Zfpbg', 'onJre1LRKSPim-C8rdj-QfuRISls', 0, 0, 1514526687, 'gh_ffb20e7314c2', '', '', '', 1514526697, 1514526697, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjuN-n5Zpth6bnnCeOT9zEnA', 'onJre1LUIEmAvyqySv2O5wGFX34w', 0, 0, 1514543729, 'gh_ffb20e7314c2', '', '', '', 1514543750, 1514543750, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjrVTHqyg-TUqPYE-5GQ3X2o', 'onJre1L_R3kcSmNkUa7oD-_tBZHI', 0, 0, 1514543964, 'gh_ffb20e7314c2', '', '', '', 1514543986, 1514543986, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjmnTXanqH0yFG6QpFQ2tGPo', 'onJre1L_gt1j7Jc-ISIfZV3Nut_E', 0, 0, 1514441350, 'gh_ffb20e7314c2', '', '', '', 1514441370, 1514441370, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzju0lMR1nJaRjjIHpgW-Pznk', 'onJre1LdXYQxZ3MRGQMwxHYJgYdw', 0, 0, 1514526989, 'gh_ffb20e7314c2', '', '', '', 1514526999, 1514526999, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjni8vTQ8uo6nIR93qvm2T70', 'onJre1Lh9VmhV8IPKh3tTJ_yusY8', 0, 0, 1514535944, 'gh_ffb20e7314c2', '', '', '', 1514535960, 1514535960, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjhb4fdmnsenTYC8IYomtmYY', 'onJre1LiDb5aK9cUZuHuvMspdmRc', 0, 0, 1514543843, 'gh_ffb20e7314c2', '', '', '', 1514543864, 1514543864, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjk23lGGjbdi6th_RJNnfwqo', 'onJre1Lnp27TvTJjswXjDlYrN70k', 0, 0, 1514499715, 'gh_ffb20e7314c2', '', '', '', 1514497606, 1514497606, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjqqkcYcY0j9mUcvd3T-DB1M', 'onJre1LoH7g4qx2SnGrPWWDEHmGQ', 0, 0, 1514451687, 'gh_ffb20e7314c2', '', '', '', 1514451714, 1514451714, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjiPXWhlToE0XUm2_du_JGfk', 'onJre1LrLvLOzy5Ig2p2Gbo2Gxgc', 0, 0, 1514449744, 'gh_ffb20e7314c2', '', '', '', 1514449769, 1514449769, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjmS9IsKZxAdDRFe42b8jYI0', 'onJre1LxQ-I7oFAf9lZv8rhOwkMg', 0, 0, 1514535868, 'gh_ffb20e7314c2', '', '', '', 1514535884, 1514535884, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjoaxlCHPpGFbp_rzPNkL2F0', 'onJre1M0VwvK5W8Q_sW1i3-WQDIE', 0, 0, 1514535259, 'gh_ffb20e7314c2', '', '', '', 1514535283, 1514535289, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjvfWESLrBjfxHDTQ6sCBDjc', 'onJre1M4uDgXYclVWkmcr-aANXj4', 1, 1514449233, 0, 'gh_ffb20e7314c2', '', '', '', 1514449258, 1514449258, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjr2DEfbD7MLKlKbKoPB9dg8', 'onJre1M70NG2bQz8jtjQ4F1Q49_s', 0, 0, 1514541048, 'gh_ffb20e7314c2', '', '', '', 1514541067, 1514541067, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjtFW2bHmVwZqRTjq3EoFxrI', 'onJre1MACEldYDiMqg2u7g_rC2fw', 0, 0, 1514472511, 'gh_ffb20e7314c2', '', '', '', 1514472553, 1514472553, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjgO0vKO6hs7_pEPmyvLjFK8', 'onJre1MCt7W69KQh5xgfMufro0gs', 0, 0, 1514543820, 'gh_ffb20e7314c2', '', '', '', 1514543842, 1514543842, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjrjD0oj6rI0GQyOrPc7rKHA', 'onJre1MEhsSwTZlO-KVwTn_kja5g', 0, 0, 1514537948, 'gh_ffb20e7314c2', '', '', '', 1514537965, 1514537965, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjgw2RMr295e-s7VvVuOBWWE', 'onJre1MGvz5WbuRaABnJeWtNYd-Y', 0, 0, 1514478882, 'gh_ffb20e7314c2', '', '', '', 1514478538, 1514478538, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjhw_Vkqz55IGlAwvVzeFUTQ', 'onJre1MMuCAK1hKTN1m5SzpaOxh0', 0, 0, 1514535499, 'gh_ffb20e7314c2', '', '', '', 1514535515, 1514535515, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjs07Zkr98OWbcMV9fkHFBpo', 'onJre1MPAyVdDoAzrVfi6CjivPro', 0, 0, 1514540409, 'gh_ffb20e7314c2', '', '', '', 1514540427, 1514540427, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjsCADQk28GyBsq8o6kQE3do', 'onJre1MTlYLGkbiXFghl3BHU3E_A', 0, 0, 1514535351, 'gh_ffb20e7314c2', '', '', '', 1514535367, 1514535367, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjg3QR1Z2CYehSMQI6enwZjs', 'onJre1MV-FvpU2PzRyo4_TEe0LII', 0, 0, 1514535423, 'gh_ffb20e7314c2', '', '', '', 1514535439, 1514535439, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjhEMYn0eiq50KT4Amxjd21Q', 'onJre1MbysdMU_5NOQjqpb1HEVHI', 0, 0, 1514535320, 'gh_ffb20e7314c2', '', '', '', 1514535335, 1514535335, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjitZG_wTpa-5kIi78TjMP74', 'onJre1MjG_V0uncqbwrXrVt3683g', 0, 0, 1514537512, 'gh_ffb20e7314c2', '', '', '', 1514537529, 1514537529, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjtP1BdwsfQ-GFmV6jHbW0uM', 'onJre1Mosu6HsjDl8jxv_rUvgGqU', 0, 0, 1514459996, 'gh_ffb20e7314c2', '', '', '', 1514460029, 1514460029, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjruw8LaL1WaDrib8oA7iam8', 'onJre1Mp46tZaImRo28nMnb-21us', 0, 0, 1514535457, 'gh_ffb20e7314c2', '', '', '', 1514535473, 1514535473, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjt7MaeOW-m0reiycXMGPRcg', 'onJre1MrnzcP5R0z27eJ4EUGuEAw', 0, 0, 1514547476, 'gh_ffb20e7314c2', '', '', '', 1514547500, 1514547500, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjuVuUiicEej5K_N1rTVyQTY', 'onJre1MyURDR_yo9rihuezNj43Nk', 0, 0, 1514535552, 'gh_ffb20e7314c2', '', '', '', 1514535568, 1514535568, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjpSrZfcnyiAstzb0Bq_vH0M', 'onJre1N8lSDY2eL934xtp5KuiOLM', 0, 0, 1514456454, 'gh_ffb20e7314c2', '', '', '', 1514456484, 1514456484, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjiNGZPxiQ7DXeuN_8q_G4lo', 'onJre1NEuyk-yT8yLkBM4bNzCaWM', 0, 0, 1514463987, 'gh_ffb20e7314c2', '', '', '', 1514464023, 1514464023, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjixhWks6R0WaS3lQPezuqpI', 'onJre1NFAKp73APQbI55x9_q-By8', 0, 0, 1514535830, 'gh_ffb20e7314c2', '', '', '', 1514535846, 1514535846, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjgcuGf8ZXn5WVKM-bf59DYU', 'onJre1NMdSLnvewA0upJgD6QkHAc', 0, 0, 1514535293, 'gh_ffb20e7314c2', '', '', '', 1514535309, 1514535309, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjgpTxeqTBiBcFfyY4SsVkWs', 'onJre1NQPYFX-0Aj3FXJWjymWPfk', 1, 1514530749, 0, 'gh_ffb20e7314c2', '', '', '', 1514530762, 1514530762, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjnATVTEbWpze_n9l42c1B_o', 'onJre1Ne5RxMeholjHRVdC7T6PNo', 0, 0, 1514449052, 'gh_ffb20e7314c2', '', '', '', 1514449078, 1514449078, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjkuqX9g9qgdTLbgaOCanFTs', 'onJre1NewequdTimz7Etbh_zQi64', 0, 0, 1514443850, 'gh_ffb20e7314c2', '', '', '', 1514443872, 1514443872, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjoRf1bPsAfmLql_m7uniyGM', 'onJre1Ni24InXG1uYQET70GHTeiM', 0, 0, 1514455038, 'gh_ffb20e7314c2', '', '', '', 1514455067, 1514455067, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjhygCvnbdynZ8N5gS4Cb7O4', 'onJre1NoqbDmxgnBXR_bOgKkSGeg', 0, 0, 1514535506, 'gh_ffb20e7314c2', '', '', '', 1514535521, 1514535521, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjgALQe4qrpe4_Rp8C-YY4X8', 'onJre1NqoPFcB8CioKPH3usH7vwk', 0, 0, 1514527756, 'gh_ffb20e7314c2', '', '', '', 1514527766, 1514527766, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjobqD2Z2da3E0v1tUVb2Uzs', 'onJre1Nu5g60-66ktBygK3l6fC5c', 0, 0, 1514535625, 'gh_ffb20e7314c2', '', '', '', 1514535641, 1514535641, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjjBPMb4hqjMo1Q_2LOd7wuk', 'onJre1NwDkwCLeBX5u4zVCFYdmdI', 0, 0, 1514450545, 'gh_ffb20e7314c2', '', '', '', 1514450570, 1514450570, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzju8tBxz5lzzFw2GXyJx30Jk', 'onJre1NyvQk5sWzE_ticdMuUnJFo', 0, 0, 1514535297, 'gh_ffb20e7314c2', '', '', '', 1514535314, 1514535314, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjmj_UQkgPJbz2_iwqSY7l_E', 'onJre1O53PLESJy0nnwQfXio6O5o', 0, 0, 1514535441, 'gh_ffb20e7314c2', '', '', '', 1514535456, 1514535456, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjkftYhbPnisc3mHROLc0lZM', 'onJre1O9OferOF-2oPmgISLKFhJk', 0, 0, 1514544049, 'gh_ffb20e7314c2', '', '', '', 1514544070, 1514544070, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjoucKQWGlLGG95l3vQU2YKc', 'onJre1OR1FaewNgKjxG_4yak_wGs', 0, 0, 1514459938, 'gh_ffb20e7314c2', '', '', '', 1514459971, 1514459971, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjgNXIXqyvbWdnEPtDgeUNDQ', 'onJre1OXXVW5oL76toXgJx6UbNVE', 0, 0, 1514540626, 'gh_ffb20e7314c2', '', '', '', 1514540645, 1514540645, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjinGpOfApmVZXVnuc4I8KQI', 'onJre1OY8bbRpy9Zgx35WLtnwdzc', 0, 0, 1514540489, 'gh_ffb20e7314c2', '', '', '', 1514540508, 1514540508, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjqGV_EkILnnsyr5368wy4wE', 'onJre1OjAORAZ9zol8KcU5OhpxNI', 0, 0, 1514536164, 'gh_ffb20e7314c2', '', '', '', 1514536180, 1514536180, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjroemy24Hz6e2UPCEFAZ1_8', 'onJre1Om2KXVm21kKAmLJyu81T0E', 1, 1514447390, 0, 'gh_ffb20e7314c2', '', '', '', 1514447415, 1514447415, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjo8ak0wjXKv3hkI4QiMekbA', 'onJre1OrtZ06LTYxtg2mfGK0GNDc', 0, 0, 1514538796, 'gh_ffb20e7314c2', '', '', '', 1514538814, 1514538814, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjgPqTv4GJ9idIjaBtr-PU1Y', 'onJre1OtqZTD_mxU0rFZAoFEkaT8', 0, 0, 1514535240, 'gh_ffb20e7314c2', '', '', '', 1514535263, 1514535268, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjoRL3asfiRHbzfZUv2ATDds', 'onJre1OvXFyUFsZ9ErGTCMGrBtIM', 0, 0, 1514535176, 'gh_ffb20e7314c2', '', '', '', 1514535195, 1514535195, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjtWHPb4Y_4dC98uTJDP_i4M', 'onJre1OwKW5J2Bv1UP0SqVn8CXbs', 0, 0, 1514535245, 'gh_ffb20e7314c2', '', '', '', 1514535264, 1514535264, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjty-RaGBIL8EGnsiBj6NmyE', 'onJre1OzSFPFnlp2VvVrEO6OThj4', 0, 0, 1514545576, 'gh_ffb20e7314c2', '', '', '', 1514545599, 1514545599, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjvgROX_3Ry5Jn__vXV2hOAI', 'onJre1P02V5agx-SVWOn6sYM9HVc', 0, 0, 0, 'gh_ffb20e7314c2', '', '', '', 1514535297, 1514535297, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjs1x3N-TyEAWAEXk1tVsccg', 'onJre1P1ROkVDnhCCJl-sTcmg_ec', 0, 0, 1514463813, 'gh_ffb20e7314c2', '', '', '', 1514463849, 1514463849, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjkSLgHEbbdPKIsTaSW4HML4', 'onJre1P2fHvZa3EryLdk_uRjMcKo', 0, 0, 1514452289, 'gh_ffb20e7314c2', '', '', '', 1514452316, 1514452316, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjlAlAIL4uerSBBL0E8XaYUM', 'onJre1P7LNRnCuD6VWllNAlLqcwM', 0, 0, 1514449871, 'gh_ffb20e7314c2', '', '', '', 1514449897, 1514449897, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjoEjEo_h_Xonri-e8WS1Smc', 'onJre1P8JChXzH9-EZFqKnQurwzs', 0, 0, 1514536869, 'gh_ffb20e7314c2', '', '', '', 1514536886, 1514536886, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjgKhGNI0wXJlLzmEaUc2Xlk', 'onJre1PAWhREBIdifUPMY0nGaJfM', 0, 0, 1514536158, 'gh_ffb20e7314c2', '', '', '', 1514536174, 1514536174, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjkYgkHnMiKJwZb3IaTqsd1w', 'onJre1PAa1aMbVWCtP6ya3vmNXRU', 0, 0, 1514535952, 'gh_ffb20e7314c2', '', '', '', 1514535968, 1514535968, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjpW5FENuJmDz2QLV85oGTSg', 'onJre1PIvLc_y2n9Q5pSplZy-2hg', 0, 0, 1514535371, 'gh_ffb20e7314c2', '', '', '', 1514535387, 1514535387, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjoQVtoAekYR9tEnIyhmt_k0', 'onJre1PNFh5qod4Q2ttme4HMrQn4', 0, 0, 1514539216, 'gh_ffb20e7314c2', '', '', '', 1514539234, 1514539234, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjnaigBS3Jx9JlQL8Mn0ey48', 'onJre1PVX57pIcPLrxrGLAv-CRao', 0, 0, 1514535625, 'gh_ffb20e7314c2', '', '', '', 1514535641, 1514535641, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjnqDMw6p7MLUcvhH5r-CQIg', 'onJre1PWPNxmgp07-jMSJRM7quUA', 0, 0, 1514538863, 'gh_ffb20e7314c2', '', '', '', 1514538881, 1514538881, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjhV0iZ7Oyy3SoKJI9oH8tuU', 'onJre1PX_BcOvcR2zkMO9aqXaLIo', 0, 0, 1514544151, 'gh_ffb20e7314c2', '', '', '', 1514544173, 1514544173, NULL);
INSERT INTO `wechat_fans` VALUES ('obVzzjvXBU2xpiUq-3v7pYPpMH_Q', 'onJre1PY8Oz5ocbLQ-H2mSoV05ow', 0, 0, 1514450714, 'gh_ffb20e7314c2', '', '', '', 1514450740, 1514450740, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
